PLwolves87
New Member
- Joined
- Jan 6, 2023
- Messages
- 31
- Office Version
- 365
- Platform
- Windows
Hi I have some textboxes and checkboxes, basically when i tick the checkbox i want the data to go to a textbox.
here is the code but i get an error please help.
'when ticked the data shall read QUARTER in textbox38, then textbox34 will display the information from combobox4,textbox19,combobox6 & textbox 38 IF NOT TICKED then textbox34 is left blank
Private Sub CheckBox3_Click()
TextBox38.Text = IIf(CheckBox3.Value, "Quarter", "")
TextBox34.value = "ComboBox4 & " " & Textbox19 & " " & ComboBox6 & " " & TextBox38 "
End Sub
here is the code but i get an error please help.
'when ticked the data shall read QUARTER in textbox38, then textbox34 will display the information from combobox4,textbox19,combobox6 & textbox 38 IF NOT TICKED then textbox34 is left blank
Private Sub CheckBox3_Click()
TextBox38.Text = IIf(CheckBox3.Value, "Quarter", "")
TextBox34.value = "ComboBox4 & " " & Textbox19 & " " & ComboBox6 & " " & TextBox38 "
End Sub