![]() |
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? |
All times are GMT +1. The time now is 10:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com