loop through the rows and then update the textboxes and captions

**js999** · 09-29-2007, 01:35 PM

This is very simple, but for some reason I am having a tough time concatenating the loop value with the textbox and caption objects.

I have a userform that has over 30 textboxes on it. I want to be able to loop through the rows on my excel sheet and then update the textboxes and captions as needed. The areas in RED are where I need help.

Thanks,
js999

Please Login or Register  to view this content.

**Leith Ross** · 09-29-2007, 01:50 PM

Hello js999,

I made a few changes to your code. You don't need to select the cells to operate on them in VBA.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**js999** · 10-02-2007, 10:52 AM

Leith,

Thanks for the help. This works like a charm.

-js999

loop through the rows and then update the textboxes and captions

LinkBack

Thread Tools

Rate This Thread

Display

loop through the rows and then update the textboxes and captions

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions