Hi everyone,
I have a button that my users can push that will display a message box that
is linked to a cell with a percent value in it. My problem is that when the
user presses the button the msgbox say:
The value of column x is: .158765224
I want this to say, " The value of column x is 15.8%" but i don't know how
to declare my variable properly to do so.
Any help would be appreciated.
JLGWhiz - 25 Mar 2008 04:08 GMT
You can do it in the message box response:
MsgBox "The value of column x is " & Format(LinkedCell, "00.0%")
If you only want whole percentage then make it "00%". Substitute the actual
cell reference for LinkedCell.
> Hi everyone,
>
[quoted text clipped - 8 lines]
>
> Any help would be appreciated.
Mike - 25 Mar 2008 04:13 GMT
MsgBox Format(Range("B1").Value, "0.0%")
> Hi everyone,
>
[quoted text clipped - 8 lines]
>
> Any help would be appreciated.