How do I change letters in a drop down box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a per diem sheet made for the month, and column B is for expense level
with a drop down list. the letters are outdated and I don't know how to
change the letters to update it. For example when I clip the drop down it's
has H-A and i want to change it to just A
 
hi,
this is done in the controls properties. In design mode right click the
control then click properties. If it is a sheet combo box, scroll down to the
"listfilerange". this will tell your where the control is getting it's data.
if it is a form combo box, scroll down to the rowsource.
you will have to change the sorce data to change the data in the box.

Regards
FSt1
 
You must log in or register to reply here.

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

Using Drop Down List or Combo Box 9
Dependent drop down dynamic range formula, off sheet. 7
drop down list 3
How do I change fonts in a DV drop down menu 1
Selecting from a drop down list 2
Formatted cell column in drop down list 1
Drop Down with dynamic named range offsheet source list 14
How to type each letter of the alphabet automatically in a specific color in Word? 0

Back
Top