• If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
  • Excel articles and downloadable files provided in the articles have not been reviewed by MrExcel Publishing. Please apply the provided methods / codes and open the files at your own risk.
    If you have any questions regarding an article, please use the Article Discussion section.
smozgur

XL2BB - Excel Range to BBCode 2.0

No permission to download
It just works every time. Effortless. Thank you.
Can we also capture actual Result(value) and Cell Number Formats?

For example, cell A1 has formula '=1500*0.15784' where the result value will be '236.76' and cell number format is '#,##0', therefore the result displayed on the table is '237'.
Resolved the installation issue and the Add-In is now working great...really a nice and effective Add-In product...keep up the great work!
smozgur
smozgur
Glad it is up and running now. Thanks for the feedback!
Unfortunately it doesn't seem to be working with Excel for MAC. I get the following error:

Run-time error '1004': Method 'Type' of object 'Validation' failed.
Excellent tool. Glad you have fixed the '2 squares' issue. I hope all posters now use this as it makes it so much easier to understand the problem/solution.
smozgur
smozgur
Thanks for the feedback and review.
Excellent feedback from smozgur, constant updating to accommodate the users. Works nicely.
smozgur
smozgur
Thanks for the review and glad you find it useful.
Love it!

Only thing I saw that still an issue for me is Named Ranges never seem to get picked up.correctly picked up. Does it only apply if they are attached to the Range highlighted?
smozgur
smozgur
Thank you for your review, @CSmith.

In the first version, named ranges were certainly an issue. However, I made a really radical change to make it work in v1.2.5. It is supposed to apply all named ranges used in formulas (formulas in the selected range). I am going to send you a private message, that would be really great if you could share a sample workbook with me that you are having trouble with this.

Thank you!
I searched all over this page for a link to download the XL2BB add-in, and didn't realize that's what the orange Download button was for in the top right corner of the page. It would help to explicitly say "Download the XL2BB Add-In" on that button, and also to have one or more links right in the article.
smozgur
smozgur
Thank you for your review, @Jon Peltier. I just updated the article to include the download link as the first item in the installation section as you recommended.
Renaming the button requires customization on the software, but it is a brilliant idea. I will include this one to our board suggestions list as it will really help.
Thank you!

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top