Extra space or spaces in Text in Forum Post. BB Code for extra space ?
. When trying to clearly explain something when answering a Thread, there are many occasions when having the ability to add extra spaces can be very useful. As we all know an annoying characteristic of most vBulletin Software is that it reduces all spaces greater than 1 back to 1
. It must be possible to do, but I have often had a few Google sessions and have not hit in it yet.
. There are loads of Links explaining how to do it in HTML code, but as yet I have found no BB Code to do it
. I simply want to be able to add a given number of spaces between words or formulas when replying in a Forum Post.
. This my best solution up until now, anyone got any better or alternative suggestions?
" big empty space " or ____________
P.s. The thing a bit in context....
….”………. A characteristic of the VBA Evaluate Method, ( or rather The building of its String Argument ), which can be helpful in particular when trying to understand the tricky Theme of the different type of quotes in a long complicated string Argument, is that the pair of effectively empty VBA Evaluate quote pairs used in conjunction with an ampersand to link The Spreadsheet “world” to the VBA Code World can have any amount of spaces between them with no effect on the code line.
These basic Code lines
Let ws.Range("B2").Value = Evaluate("=" & ws.Range("A1").Address & "") 'Explicit Version
Let ws.Range("B2").Value = Evaluate("" & ws.Range("A1").Address & "") 'Implicit Default
. May be rewritten
Let ws.Range("B2").Value = Evaluate(" big empty space " & ws.Range("A1").Address & " big empty space ") '
. As long as there is something in the total string to that can be evaluated this will not error. The explanation would be that within the VBA Evaluate “ “ pair nothing is being evaluated. It is a dead space. ( Note in parsing that it is common practice to leave out the “” & and & “” pair,
Let ws.Range("B2").Value = Evaluate(ws.Range("A1").Address)'Common but dangerous variation
. This can however catch you out as at least one “” & is good practice so as to ensure that a string is taken should the thing ____ inside the “” & _____ & ”” happen to be a number
. - http://www.excelforum.com/excel-prog...ml#post4183530
. There will be situations where this can help later to identify which quotes are which, or to which “world” they belong…….”
Demonstration in Code Window
Please Login or Register to view this content.