MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Getting Ranges from spreadsheet into a Text Box?

Posted by Steve on January 30, 2001 5:26 PM

I am sure this is quite simple but I can't figure it out. I have TWO sheets one is called "Menu" and the other is called "Stock Listing".

What I have is a button on the "Menu" sheet that when it is pressed opens a user form hopefully displaying sales figures. What I need to do is display the total stock value from the "Stock Listing" sheet into a text box on the User Form pop up box.

Am I along the right lines by thinking it is something to do with the Range function i.e. txtBox1=Range("G4")

Can anyone help, please.....

Best Regards


Posted by cpod on January 30, 2001 8:30 PM

yourformname.txtbox1 = worksheets("stock listing").range("G4")