ColdGeorge
Active Member
- Joined
- Aug 21, 2012
- Messages
- 407
- Office Version
- 2016
- Platform
- Windows
Hi all
I have a userform with a combobox populated with following code
Range R75:R105 is full with dates (dd/mm/yyyy), what I want to do is that when I click on a date of the combobox, for instance 01/01/2021 and when I hit the button Go. Select the cell having same date (01/01/2021). Any help will be appreciated.
ColdGeorge
I have a userform with a combobox populated with following code
VBA Code:
Private Sub UserForm_Initialize()
Dim rango, celda As Range
Set rango = Worksheets("actividad").Range("R75:R105")
For Each celda In rango
ComboBox1.AddItem celda.Value
Next celda
End Sub
Range R75:R105 is full with dates (dd/mm/yyyy), what I want to do is that when I click on a date of the combobox, for instance 01/01/2021 and when I hit the button Go. Select the cell having same date (01/01/2021). Any help will be appreciated.
ColdGeorge