View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe Powers Joe Powers is offline
external usenet poster
 
Posts: 4
Default dynamic formatting of cells

Hi all,
I have a workbook that contains a data page and a report page. The
report page is generated by a combobox on the data page which basically
lets the user pick a financial indicator from a list. When the indicator
is selected, the report fills with the #'s for that indicator. However,
each indicator has a different # format, i.e. I have $, % and 2 decimal
# formats). I would like the report page to have the # format of the
indicator selected on the data worksheet. Is there a simple way to
accomplish this?
TIA



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!