Reading data from excel into VBA

VBAmalta89

Board Regular
Joined
Mar 25, 2011
Messages
116
Is it possible to insert data into a user form from an Excel worksheet?

What I mean is that i have a user form with a number of text boxes. however, i want the data in these text boxes to come from within a specified cell in an excel worksheet rather than the user inputting the data in the text box. I know this is possible when having combo boxes or drop down boxes but id like to do it with a text box as well.

The reason im doing this is to generate a sort of report of the data in a worksheet. If there is any other way please let me know coz i am new to VBA

Thanks
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
What have you tried? Have you done any experiments or looked for examples online?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top