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