having user input info, want to check before pasting

**roth_nj** · 03-19-2009, 02:04 PM

i am writing a program that asks the user for an input and sets it equal to a variable.

i want to look thru a column for this variable, if it is not in it, then paste it at the end of the column. if it is in already, throw up a dialog box saying its already used and exit the sub.

i dont know how to set up this kind of thing up???

vlookup in combination with an if statement?

any help would be great.

thanks

nick

**roth_nj** · 03-19-2009, 02:22 PM

the following code is what im thinking
i put in the word "thing"
i dont know how to say if "any value in column A on sheet A" equals
and Location is my variable

Please Login or Register  to view this content.

**Leith Ross** · 03-19-2009, 02:22 PM

Hello roth_nj,

You can use the Find function for range. This will either return the address of the cell of the search value or nothing. You can use anIf ... Then to set the value like this...

Please Login or Register  to view this content.

**roth_nj** · 03-19-2009, 02:26 PM

thanks, that helps me out.

ive done C++ programing before but this is my first program with excel. i have no problem figuring stuff out, i just dont really know most of the functions available

**Leith Ross** · 03-19-2009, 02:31 PM

Hello roth_nj,

To find information on properties, methods, and events for VBA objects use the Object Browser. To view the Object Browser, open the VBE from Excel using ALT+F11 then press F2. Use the VBA help files for more information about arguments and syntax. Microsoft also has online help for VBA. To learn about the functions that are available in VBA you should buy a book on VBA.

**roth_nj** · 03-19-2009, 02:48 PM

for whatever reason on my computer here at work, the help isnt working. i go to type something in and its frozen. its works in excel though.

and i bought vba for dummies and am about halfway thru reading it