• 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.1

No permission to download
Overview Updates (7) Reviews (14) History Discussion
Latest Rating
Georgiboy
Brilliant, it's part of what sets this forum apart from others.
smozgur
smozgur
Thanks for the feedback, @Georgiboy!
T
thanks for this new release. have a nice WE
smozgur
smozgur
Thanks for the feedback!
T
I cannot install the macro as it says it is blocked for security reason. I read the Peltier article and it showed going to the properties of the xlam file and unblocking. However, when i rt. click the file and go to properties, my properties dialog does not look at all like the one shown. It has only one tab, "General" (not Security, Details, and Previous versions). And the "General tab" does not have the verbiage to unblock as shown in the article. Any suggestions as to how to unblock and install?
C
I have it installed but it does not show when I open up Excel and when I try to add it as an Add On nothing happens...have I missed a trick?
smozgur
smozgur
After unzipping the xl2bb.xlam file, right click on it and Properties->General->Security section at the bottom, and uncheck the Unblock checkbox if it is checked already. Then follow the instructions in the Overview page at the top of this page. If it still doesn't work in your computer, then try the alternative installation with XLSTART folder (which actually works 100%).

Also, this is the Review area that is supposed to contain reviews, so I suggest asking for help in the Discussion section instead. In fact, there are many other questions and solutions like yours over there.
Sufiyan97
Very helpful to grab data.
smozgur
smozgur
Thanks for the feedback.
XEVEN__
I dont think I have ever had so much difficulty trying to paste an image or download an add-in. With the exhaustive instructions here to add the xl2bb I guess I should have been an computer programer.
smozgur
smozgur
I understand that you only use excel on what you consider a basic level as you stated in a question you asked but sorry to hear that the standard add-in installation instructions didn't work for you easily. You could still ask for help installing the add-in in the discussions on this topic, and I am sure one of the other members who downloaded and installed it would help you quickly.

Pasting an image on the other hand could be done with Ctrl + V keys or right-click in the editor and selecting the command "Paste" in the context menu once you take the screenshot of the image from the original source.
D
It just works every time. Effortless. Thank you.
N
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'.
R
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!
P
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.
jmacleary
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.
cyrilbrd
Excellent feedback from smozgur, constant updating to accommodate the users. Works nicely.
smozgur
smozgur
Thanks for the review and glad you find it useful.
CSmith
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!
J
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!

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
Back
Top