How to display text boxes.

Bidwin · Apr 24th, 2002, 02:15 PM

I have a user form that's supposed to display data taken from a related worksheet. Data is moved from the worksheet to textboxes with statements similar to this: "TextBox1 = Worksheets(1).Cells(2, 7)", but I can't get the textboxes to display the data moved to them. Can anyone tell me how to do that? I can see data being moved into the textboxes when I step into the code and have my Watch window active.

Or, if there's a better way to do this please let me know.

Thanks in advance for your help,
Bidwin

Bidwin · Apr 24th, 2002, 08:55 PM

Never mind, I figured it out.

gareth · Apr 25th, 2002, 02:25 AM

Good I was goinf to explain how to do it

Apr 25th, 2002, 02:25 AM	#3
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Good I was goinf to explain how to do it __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 02:15 PM	#1
Bidwin New Member Join Date: Apr 2002 Posts: 27	I have a user form that's supposed to display data taken from a related worksheet. Data is moved from the worksheet to textboxes with statements similar to this: "TextBox1 = Worksheets(1).Cells(2, 7)", but I can't get the textboxes to display the data moved to them. Can anyone tell me how to do that? I can see data being moved into the textboxes when I step into the code and have my Watch window active. Or, if there's a better way to do this please let me know. Thanks in advance for your help, Bidwin

Apr 24th, 2002, 08:55 PM	#2
Bidwin New Member Join Date: Apr 2002 Posts: 27	Never mind, I figured it out.