Hi guys,
Im having trouble figuring this out. I have 2 comboboxes and 7 textboxes. What it does combobox1 will show all the names (Range B)which is already filtered in sheet Report. Once a name is selected combobox2 will show all the dates (Range C) that corresponds to the name selected. What im having trouble is how will I transfer the data from the cell to my textboxes.
Let me give an example just to make it clear:
Combo1 Combo2
Mike - 04/12/2013
- 05/15/2013
- 02/15/2014 <-- lets say I select this
- 03/15/2015
textbox1 = cell D, textbox2 = cell D, textbox3 = cell E, textbox4 = cell F,
textbox5 = cell G, textbox6 = cell H, textbox7 = cell I
Now if in case I change the date textboxes value will also change.
Really having trouble with this. Hope somebody can help me out
Im having trouble figuring this out. I have 2 comboboxes and 7 textboxes. What it does combobox1 will show all the names (Range B)which is already filtered in sheet Report. Once a name is selected combobox2 will show all the dates (Range C) that corresponds to the name selected. What im having trouble is how will I transfer the data from the cell to my textboxes.
Let me give an example just to make it clear:
Combo1 Combo2
Mike - 04/12/2013
- 05/15/2013
- 02/15/2014 <-- lets say I select this
- 03/15/2015
textbox1 = cell D, textbox2 = cell D, textbox3 = cell E, textbox4 = cell F,
textbox5 = cell G, textbox6 = cell H, textbox7 = cell I
Now if in case I change the date textboxes value will also change.
Really having trouble with this. Hope somebody can help me out