Hi everyone,
How can I add a Selection-box in a pop up?
I have an InputBox, that once value entered, it adds the value to a given cell:
____________________________________________________
Sub AddValue ()
Dim Lastrow As Long
Lastrow = Cells (Rows.Count, "A").End(x1Up).Row +1
Dim firstvalue As String
firstvalue = InputBox("Enter first value","First Value")
Dim LString As String
LString = firstvalue
Cells (Lastrow, 1).Value = firstvalue
Dim secondvalue As String
secondvalue = InputBox("Enter second value","Second Value")
LString = secondvalue
Cells (Lastrow, 2).Value = secondvalue
_________________________________________________________
What I want to do, is that for the secondvalue it shows me a selection box of a list I have on a second worksheet, and if I select one element of the list, it will be shown on the given cell.
Big thanks,
Rafael
How can I add a Selection-box in a pop up?
I have an InputBox, that once value entered, it adds the value to a given cell:
____________________________________________________
Sub AddValue ()
Dim Lastrow As Long
Lastrow = Cells (Rows.Count, "A").End(x1Up).Row +1
Dim firstvalue As String
firstvalue = InputBox("Enter first value","First Value")
Dim LString As String
LString = firstvalue
Cells (Lastrow, 1).Value = firstvalue
Dim secondvalue As String
secondvalue = InputBox("Enter second value","Second Value")
LString = secondvalue
Cells (Lastrow, 2).Value = secondvalue
_________________________________________________________
What I want to do, is that for the secondvalue it shows me a selection box of a list I have on a second worksheet, and if I select one element of the list, it will be shown on the given cell.
Big thanks,
Rafael