Automatically Highlight single item in list box

G

GeorgieGirl

I am using File Dialog s described in Knowledge Base Article 824272 on a form
to the user can Browse for the file they want to import. I have modified the
code so that only Excel files are listed. The user is only selecting a
single Excel spreadsheet, which properly appears in the list box.
However, the user must highlight the file path and name before requesting
clicking the button that uses a macro to import the file on the form. If it
is not highlighted, the name in the listbox is ignored.
It works OK when the user highlights it, but seems hokey when there is only
one item in the bos. Is there a way i can programatically highlight the list
box entry?
Thanks for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to Combine reports to's to a single box? 0
Highlight multiple items in listbox based on textbox item 1
VBA - exporting serial letters to single documents 0
Unable to display values in 2nd list box from 1st list box selection 2
Brain cramp! setting value of multiselect list 7
Using VBA to select Items in multiselect Listbox 1
default is chosen or highlighted in the list box 3
Multi-select list box 1

Top