Hi all, totally new here, treat me as a retard when I say something stupid, and thanks for your help in advance.
I have two columns of texts. 1 column contains category, such as apple, orange, banana, etc. Another column contains raw data but part of it has the category name, such as apple11111, orange is good, banana1212 soso, etc.
I have 1000 thousand raw data, 25 categories.
I would like to categorize...
User Profile
Collapse
-
comparing 2 strings of Texts
-
Thanks very much. txtTextBox.Enab led works perfectly. appreciate it. ^_^... -
how to lock a box in a form?
Hi all,
I have an user_form in excel that lets the users input and modify data, which will be stored in an access database. There's one box in this form that I would let the users enter data in, but I would like to lock this box so that it can not be modified when the form is reopened.
Does anyone know the VB codes to lock a box on a user_form? or how else can I approach this issue? any suggestion is greatly appreciated.... -
Thanks very much for your reply. So I suppose that that End If should be added after Next right?Leave a comment:
-
Help~how do I do nested if?
Hi... would like to start off a little useless info. about myself... first time using VB... totally confused and lost... treat me as a retarded and thanks for your help in advance.
I get the "Block if without end if" error on the codes below. I don't see where I am missing an End If... please help~ ;)
[CODE=vb]
If myChoice = "CREATION" Then
Dim c As Range
For Each c In Sheets("RMs").R ange("F2:F500")...
No activity results to display
Show More
Leave a comment: