ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,251
- Office Version
- 2007
- Platform
- Windows
Hi,
Im looking for a simple code that will do the following.
Worksheet is called DATABASE
The code will look in column F ONLY for a cell which has value present.
Once a cell is found a userform listbox will be populated with that customers name which will be taken from column A
Once all cells have been checked the user can select a customer in the populated listbox & be taken to that customer in the worksheet.
Example.
Row 50 has no value in cell F
The name on Row 50 column A "TOM JONES" will then be placed into a userform listbox "USERFORM1 / LISTBOX1"
The code continues to look for empty cell values & do the same as above.
Once completed the listbox is compiled with all the available customers names ready for selection
Im looking for a simple code that will do the following.
Worksheet is called DATABASE
The code will look in column F ONLY for a cell which has value present.
Once a cell is found a userform listbox will be populated with that customers name which will be taken from column A
Once all cells have been checked the user can select a customer in the populated listbox & be taken to that customer in the worksheet.
Example.
Row 50 has no value in cell F
The name on Row 50 column A "TOM JONES" will then be placed into a userform listbox "USERFORM1 / LISTBOX1"
The code continues to look for empty cell values & do the same as above.
Once completed the listbox is compiled with all the available customers names ready for selection
