Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with populating textboxes in relation to drop down list
I have a drop-down list in a form, a number of text boxes are then populated
from this value. For example the Date text text box is to be filled with data to the left of the tourref value etc. I have used the ".Column()" property eg. 'On Change of Tourref Drop-Down Private Sub tourref_Change() DateText.Value = tourref.Column(-1) CountryText.Value = tourref.Column(1) PlaceText.Value = tourref.Column(2) AdultText.Value = tourref.Column(3) ChildText.Value = tourref.Column(4) End Sub However, this does not work on the "bookings" sheet at all. But does work on others. Any ideas why? or how i can do it differently? Thanks -- Cheers, Ben Remove your.tonsils to reply "You only live once but if you do it right once is enough!" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating other cells based on a choice from a drop-down list | Excel Discussion (Misc queries) | |||
drop down list populating | Excel Discussion (Misc queries) | |||
Problem - Shapes.Textboxes | Excel Discussion (Misc queries) | |||
Drop-down list problem | Excel Discussion (Misc queries) | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions |