Thread: Format change when user select a Factor on drop down box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
liem liem is offline
external usenet poster
  
Posts: 22
Default Format change when user select a Factor on drop down box
I have a drop down box with many Factors. when the user select one factor
below I like the data to show up as correct format on the out put .
How can i do it ?
Drop down box 1- Merchandise $
2- Gas $
3- Merchandise margin %
4- Gas margin %

on cell A4 I format as Currency.




--
thanks
Reply With QuoteReply With Quote