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
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