F
Font
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?
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?