ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Retrieve date from a list in another worksheet (https://www.excelbanter.com/excel-programming/388220-retrieve-date-list-another-worksheet.html)

Font

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