Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve date from a list in another worksheet
I'm creating a personalized form that requires accessing name/phone/fax data
from a list database in another worksheet (in the same workbook). I've had limited success in retrieving the data. 1. A pulldown list works but is limited to 750 lines (database additions will exceed that number by 2008) and I can only link the 1 column (name), not the 3 columns (name/phone/fax) needed. 2. A forms LISTBOX works well for the 3 column data (name/ph/fax) and typing in the name brings it up fine but: a. If the text is highlighted in the ListBox it STAYS highlighted, and the color is blue and PRINTS that way. Can I change the highlight color to white or automatically de-select the highlight? b. Can I link the ListBox to another worksheet and basically duplicate the info automatically without inputting it on that sheet as well? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieve data from Drop Down List | Excel Discussion (Misc queries) | |||
retrieve entry from a list in excel | Excel Programming | |||
Retrieve a the date created date of an Access Table in Excel using VBA | Excel Programming | |||
Text retrieve in a list-like WS | New Users to Excel | |||
Programatically retrieve a list of public functions. | Excel Programming |