Help with formatting VBA code when concatenate 2 cells into a Txt box

[ExcelNoob223]

I am seeking help! Lol. I have the following, which I'm using to concatenate 2 cells into a text box. When the cell updates it also updates the txt box. However, the formatting is wrong when it concatenates the 2. B5 needs to be a number and C5 should be a percent. Does anyone know a quick solution for this?

Current example: B5=50, C5=10%
Answer = 500.10

What I would like it to look like:
Answer = 50 - 10%

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

Welcome to the Forum ExcelNoob223 !

Try this. I did not test it, but if you have trouble attach your file*.

Please Login or Register  to view this content.

*The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

[ExcelNoob223]

I've attached my excel file as instructed. It partially works as it has % but no number.

[Rick Rothstein]

Please Login or Register  to view this content.

You could have also used VBA's FormatPercent function...

Please Login or Register  to view this content.

[ExcelNoob223]

This solution gives me " 50 - " and removes the percent and #.

[salim ali]

ME BY THIS MACRO CAN HELP YOU

Please Login or Register  to view this content.

[6StringJazzer]

I've attached my excel file as instructed.

I don't see it....

[ExcelNoob223]

Huh, I don't know why. I thought I followed the directions. But it doesn't seem to do anything after I click "close the window"

[Rick Rothstein]

This solution gives me " 50 - " and removes the percent and #.

Are you referring to the code line I posted in Message #4? If so...

1) What version of Excel are you using?

2) What exactly is in cell C5 when that code line is executing?

[6StringJazzer]

Huh, I don't know why. I thought I followed the directions. But it doesn't seem to do anything after I click "close the window"

Sometimes this happens if the file exceeds the size limit. It's not obvious. .xlsx files can be up to 1MB. If you zip it, it can be 9.77MB.

[ExcelNoob223]

1) What version of Excel are you using?

2016

2) What exactly is in cell C5 when that code line is executing?[/QUOTE]

It will be just a % like OI as a % of total sales. I will use this to have a txt box update in my graph. Im trying to automate this process to update as new data is pulled from Hyperion Planning.

[Rick Rothstein]

Given your version of Excel and the fact that you have a number in cell C5, I can see no reason why the code I posted in Message #4 would not have worked for you. Given that, I don't know what to tell you other than to use one of the other solution if it works for you.