MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using a Userform to modify a record

Posted by lenze on August 13, 2001 8:03 AM

I have a source table with several thousand records containing a unique identifier in Column A. In column G I have a YES/NO field with NO being the default. I would like to use a userform to allow someone to input the unique Identifier and when they Click OK, the correct record would be found and the value in Column G would be changed to YES. I can find the correct record, but do not know how to select and edit column G.

Posted by Ivan F Moala on August 13, 2001 9:19 PM

your already half way there.......if you can get
the record then the record.offset(0,6) gives
you column g.

eg Record.Offset(0,6)="YES" depending on how
you got your record in the 1st place.

Post code if you need more..or syntax


Posted by lenze on August 14, 2001 7:20 AM

Thanks Ivan: It works great. I knew it had to be simple, but I was drawing a blank. Thanks Again