I have a macro that has a message box that allows a user to input a %
I would like it amended so that it displays the current % in the message box so that the user can click ok if there was no change or simply amend it
It would be appreciated if someone could kindly assist me
Please Login or Register to view this content.
Hi, you can do this:
but why do you define tempStr as String? A percentage is nothing more than a formatted value.Please Login or Register to view this content.
Cheers
Erwin
Last edited by Eastw00d; 06-05-2020 at 01:34 AM. Reason: typo
I started learning VBA because I was lazy...
Still developing.... being more lazy...
Thanks for the reply
How do I set this up without the tempstr ?
Also message box now how 0 in message box after using your code instead of 10% which is in cell I1
Not sure if I understand you, but you can do something like this:
The default value is the value taken from the sheet, that is existing.Please Login or Register to view this content.
Cheers
Erwin
Thanks Erwin
Where I have 2 sheets, and have 10% in I1 on both sheets, the first input box appears with 10 and the second one also with 10, although the % on sheet2 is 5%
I would like this amended and secondly would like the default % to appear in message box for eg 10%
Hi Howard, since you are working with the WITH-END WITH statement, you only have to add a dot
I admit that I didn't see that before ....Please Login or Register to view this content.
But you must make clear in your text, which percentage/which worksheet you are changing/displaying.
Now it is not clear.
Cheers
Erwin
thanks for your input, which I have noted
code work now on both sheets
It would be appreciated if you could amend code so that % appears after number in message box/inputbox
have shown screen prints of how it is displaying currently and how I would like it to appear
That, my friend, is not so easy, because the output must be a number, not a string. After all, I think you want to calculate with it.
But I will see what I can do.
Cheers
Erwin
It is not completely fool-proof, but it will do:
CheersPlease Login or Register to view this content.
Erwin
Hi Erwin
Thank you very much. Code works perfectly -just what I was looking for
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks