goldenvision
Board Regular
- Joined
- Jan 13, 2004
- Messages
- 234
I have spent a couple of hours searching for a solution to this problem and either I am not asking the question correctly or it cannot be done.
This is my problem. On a user form I have a combo box which is populate with vehicle marques. Each of these marques relates to a namd range on a spreadsheet. Selecting a marque from the combo box populates a listbox with records from that range.
What I want to be able to do is click a record (which has a unique ref number) and search the master list then populate a series of text boxes with the selected record.
Each record has around 40 columns of data, therefore the named ranges only contain an abridged version of the data.
Is what I am asking possible?
Any pointers would be greatly appreciated as I don't have a huge amount of hair left to pull out!!
This is my problem. On a user form I have a combo box which is populate with vehicle marques. Each of these marques relates to a namd range on a spreadsheet. Selecting a marque from the combo box populates a listbox with records from that range.
What I want to be able to do is click a record (which has a unique ref number) and search the master list then populate a series of text boxes with the selected record.
Each record has around 40 columns of data, therefore the named ranges only contain an abridged version of the data.
Is what I am asking possible?
Any pointers would be greatly appreciated as I don't have a huge amount of hair left to pull out!!