User Profile

Collapse

Profile Sidebar

Collapse
removefromp
removefromp
Last Activity: Jul 10 '08, 07:58 AM
Joined: Sep 11 '07
Location: san francisco
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • removefromp
    started a topic comparing 2 strings of Texts

    comparing 2 strings of Texts

    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...
    See more | Go to post

  • removefromp
    replied to how to lock a box in a form?
    Thanks very much. txtTextBox.Enab led works perfectly. appreciate it. ^_^...
    See more | Go to post

    Leave a comment:


  • removefromp
    started a topic how to lock a box in a form?

    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....
    See more | Go to post

  • removefromp
    replied to Help~how do I do nested if?
    Thanks very much for your reply. So I suppose that that End If should be added after Next right?
    See more | Go to post

    Leave a comment:


  • removefromp
    started a topic Help~how do I do nested if?

    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")...
    See more | Go to post
No activity results to display
Show More
Working...