change controlsource for textbox depending on combobox selection

M

Maverikk

Hi, I have a userform with 3 cascading comboboxes, and a textbox. I need the
controlsource of the textbox to change depending upon the selection in
combobox3. I am looking for the code. I have in mind something like: If
combobox3.value = "wages" then textbox1.controlsource = sheet3, A1 etc. but
cant get it to work, also tried
If TextBox1.Value = w Then TextBox1.ControlSource =
Worksheets("main").Range("A1")
If TextBox1.Value = x Then TextBox1.ControlSource =
Worksheets("main").Range("b1")
Can anyone help please?
 
O

OssieMac

If ComboBox1.Value = "wages" Then
TextBox1.ControlSource = "Sheet3!A1"
End If

You enter it the same way you would enter it in the Properties dialog box
except enclose it in double quotes in the code.
 
M

Maverikk

Thanks Ossie Mac - really owe you one! Perfect.

OssieMac said:
If ComboBox1.Value = "wages" Then
TextBox1.ControlSource = "Sheet3!A1"
End If

You enter it the same way you would enter it in the Properties dialog box
except enclose it in double quotes in the code.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Textbox input goes to 2 sheets in same wbk 0
controlSource ques 7
TextBox Change/Exit problem 3
Problem using CONTROLSOURCE... only works when sheet5 is active 0
Using ControlSource property in Textbox in UserForm 3
Date showing as numbers in Textbox on Userform 2
Find using a variable value 8
Validate Textbox/Userform Number Range 2

Top