Changing the active cell value to the value of a text box in a form

spike101
03-11-2004, 06:21 AM
Hi,

I need some help, I need my worksheet to stop at a cell that has the same value as a textbox in my form.

I think the following is the code, but my overall function doesn't work. Dawgs. Is this the correct format to use? If not, could you suggest alternate methods.
If ActiveCell.Value <> txtProductCode.Value Then

Thanks

Mike Rosenblum
03-11-2004, 07:26 AM
Is this a .Net Question? (It will affect how we reply).

In short, your code looks ok for VBA, but not for VB 6.0 nor for VB.Net.

Let us know?

-- Mike

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum