posting code

[jerry12302]

OK, here it goes...

<font face=Calibri><SPAN style="color:#00007F">Sub</SPAN> test()<br>    <SPAN style="color:#007F00">'testing post using html</SPAN><br>    <SPAN style="color:#00007F">If</SPAN> postlooksgood = <SPAN style="color:#00007F">True</SPAN> <SPAN style="color:#00007F">Then</SPAN><br>        MsgBox "HTML works!"<br>    <SPAN style="color:#00007F">Else</SPAN><br>        MsgBox "I give up."<br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br><br></FONT>

 

[jerry12302]

That was using 'convert selected code as HTML'.

I don't know what else to try.

Also, the addin does not stay in Excel. Every time I open Excel I have to install the addin again.

 

[MrKowz]

That was using 'convert selected code as HTML'.

I don't know what else to try.

Also, the addin does not stay in Excel. Every time I open Excel I have to install the addin again.

Try reposting your code in the "Test Here" part of the forums: http://www.mrexcel.com/forum/forumdisplay.php?f=14. These particular forums (About This Board) has HTML disabled.

As far as the add-in not staying in Excel. Try placing the add-in within the add-ins folder and then ticking the box for it under Add-Ins.

 

[jerry12302]

OK, that worked on the other board, not exactly the appearance I expected, but the code is indented, and no garble is showing.

I moved the .xla file to the addins folder and ran it from there. It works, and it is checked in the Excel addin manager, but it does not appear in the VB editor addins manager box. I do get the options to convert code to HTML (or BB), but again, when I close Excel and reopen it and go to the VB editor, those options do not appear again under tools. I have to re-run the .xla file.

 

[MrKowz]

Are you working off of a network? I have had this issue at a past employer where we all worked on WYSE Thin-Clients (dummy terminals). I was not able to save any personal settings on any programs (they were reset to default when I closed/reopened).

Another possibility, try opening excel on its own (don't open through the .xla file), and go to the Excel Add-In Manager. From there, make sure the box is ticked, and click OK. This should enable it to work going forward.

Also, when using the VBHTMLMAKER addin, be sure to still wrap your code in [CODE][/CODE] tags so that we are able to scroll through the code easier.

 

[Smitty]

Also, when using the VBHTMLMAKER addin, be sure to still wrap your code in [CODE][/CODE] tags so that we are able to scroll through the code easier.

That's kind of redundant. The VBHTML Maker should render the code just as it is in VBA, and won't need code tags. Although it's not going to indent code that hasn't been indented by the user.

 

[MrKowz]

That's kind of redundant. The VBHTML Maker should render the code just as it is in VBA, and won't need code tags. Although it's not going to indent code that hasn't been indented by the user.

I meant as in giving it its own scroll window. This is really nice to do when there is explanation about the question/code before or after the actual code posting. If the code is several hundred lines long (which we do sometimes see here on the forums), it is sometimes tricky to pair the explanation with the code.

Or if the indention goes WAY out... never know how deep someone might nest things.

 

[Peter_SSs]

Also, when using the VBHTMLMAKER addin, be sure to still wrap your code in [CODE][/CODE] tags so that we are able to scroll through the code easier.

Perhaps I've not understood what is going on here but for me, that renders the whole vba code onto a single line - no vertical scroll bar & a huge amount of horizontal scrolling. Code is effectively unreadable.