View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Heather Heather is offline
external usenet poster
 
Posts: 148
Default Highlight a cell and a message box

is there a way to highlight this cell as well and ask the user for how much
they would like to discount?
' Formats the Discount Percentage
.Range("H1").Select
Selection.NumberFormat = "0.00%"

Thank you!