Maxicus
02-18-2018, 01:07 AM
Hi
I am trying to save the text input in a textbox based on the combobox selection. for example
A combobox with the options of :
(Sheet3 Cell A1) Colour
(Sheet3 Cell B1) Animal
(Sheet3 Cell C1) Car
(Sheet3 Cell D1) Country.
A textbox where the user can input a text.
A Button that saves the textbox text to a dynamic name range.
I want the text in the textbox to be saved under the dynamic name range based on the selection of the combobox.
for examlpe, if i have chosen Colour and wrote blue in the textbox, i want it to save the text (blue) on the next available empty cell in Sheet3 Cell B2.
thanks in advance
I am trying to save the text input in a textbox based on the combobox selection. for example
A combobox with the options of :
(Sheet3 Cell A1) Colour
(Sheet3 Cell B1) Animal
(Sheet3 Cell C1) Car
(Sheet3 Cell D1) Country.
A textbox where the user can input a text.
A Button that saves the textbox text to a dynamic name range.
I want the text in the textbox to be saved under the dynamic name range based on the selection of the combobox.
for examlpe, if i have chosen Colour and wrote blue in the textbox, i want it to save the text (blue) on the next available empty cell in Sheet3 Cell B2.
thanks in advance