Thread: VBA Combo Box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MTinsley MTinsley is offline
external usenet poster
 
Posts: 3
Default VBA Combo Box

I normally use a format control drop down box. This is my first time using a
VBA Combo Box. I have two questions that are probably very basic but I can't
get this figured out.

I am using ListFillRange to define a column that has dates. This is
working, however the selection is displayed as a seriel number.

How can I format the display of the user's selection to be in a mmm-yy format?

Also, how do I link a cell to pull the selection from the combo-box?

Thanks in advance for any assistance.