View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scotty9349 Scotty9349 is offline
external usenet poster
 
Posts: 11
Default Using combobox to find column

I am working on a rolling 12-month budget spreadsheet. The first of the 12
months can be any month.

What I would like to do is have a combobox populate the months in order Jan,
Feb, etc. Then when the user selects say June it will select the column in
which June resides. Keep in mind that June could be anywhere in the first 12
columns.

I can populate the combobox, but the order the months are populated is
identical to the order the months are listed across the top row.