Rlb53
08-27-2011, 05:25 PM
I have a Userform created.
Within this userform is a ComboBox.
The Combobox is assigned to a list of worksheets.
I also have a textbox within the same userform.
I would like to select a worksheet within the combobox and have information from a specified cell in the selected worksheet display in the textbox. (the cell with the desired information is in the same location within each worksheet, "F2")
At the moment I have the combobox named as "Material_On_Hand".
The information provided from the Row Source is accurate.
The current code I have setup within the textbox is
TextBox1.Value = Sheets(Material_On_Hand.Value).Range("f2").Value
How may I display the desired information within the textbox as the selected worksheet is changed in the combobox.
Thank you for your assistance.
Within this userform is a ComboBox.
The Combobox is assigned to a list of worksheets.
I also have a textbox within the same userform.
I would like to select a worksheet within the combobox and have information from a specified cell in the selected worksheet display in the textbox. (the cell with the desired information is in the same location within each worksheet, "F2")
At the moment I have the combobox named as "Material_On_Hand".
The information provided from the Row Source is accurate.
The current code I have setup within the textbox is
TextBox1.Value = Sheets(Material_On_Hand.Value).Range("f2").Value
How may I display the desired information within the textbox as the selected worksheet is changed in the combobox.
Thank you for your assistance.