Re:- Text Format in Forums ---o00o---`(_)`---o00o---

[DocAElstein]

Re:- Text Format in Forums ---o00o---`(_)`---o00o---

'' An / To :- Mr Excel Forum
'' Von / From :- Alan Elston
Re:- Text Format in Forums
'' Hallo,
'' I `ve just recently started using this Forum in English and German
'' (I’m an old English Physicist, but have lived in Germany for over 10 years)
'' I’m a bit new to VBA (and Computers all together, - bit of a “late starter”!!)
'' I tend to write my questions and answerers either in a WORD,
'' (because I can check my spelling) .. or I write it as '' comment in
'' the VBA Code Editor (Because I the write and check the code at the same time)
'' While I’m at it I do a bit of Formatting with colours etc
'' When I copy into your message box it always comes out
'' black and white, so I have to start again..
'' Is there a way of getting over this?
'' – It’s not too important, just thought I’d ask in passing.
'' Thanks
'' Alan Elston
'' Baveria
'' Germany.
'' P.s. It’s a nice Forum..I get a better response than in the German ones

 

[Scott Huish]

Re: - Text Format in Forums ---o00o---`(_)`---o00o---

Not sure what you're after exactly. Your text is a bright green but you should know that that is very hard to read that way.

 

[DocAElstein]

Re: - Text Format in Forums ---o00o---`(_)`---o00o---

Sorry about the green:--I just sort of thought it suited with comments as comments are green in VBA.
If I use green again I'll use Dark green. I just posted something in Excel forum before I got your reply,
so that was in bright green as well... sorry,,.. but at the same time I posted something in Access forum
in Purple. As I said it wasn't too improtant, I'll moderate my formating in future!!!!

 

[Scott Huish]

Re: - Text Format in Forums ---o00o---`(_)`---o00o---

I think I understand what you mean now. I don't think what you are asking is possible. I do know, at least in Firefox, misspelled words are underlined when you are typing them.

 

[DocAElstein]

Re: - Text Format in Forums ---o00o---`(_)`---o00o---

Ok, thanks...
.. In the meantime I have another problem..
.. I cant allways seem to reply quickly to the replies that I get.
.. That is to say, I have to keep re-logging in or selcting a different Reply box, with or without a quote
.. It takes about 20 times before it seems to work.
.. Often then I have to reply to my original Thread and not necerssarilarly to the reply that I got.
.. I'm not sure then if that person who replied gets to see if I replied to him???

 

[Peter_SSs]

Re: - Text Format in Forums ---o00o---`(_)`---o00o---

.. I cant allways seem to reply quickly to the replies that I get.
.. That is to say, I have to keep re-logging in ...

When you are logging in, tick the "Remember Me?" box just under your username.

 

[DocAElstein]

Re: - Text Format in Forums ---o00o---`(_)`---o00o---

When you are logging in, tick the "Remember Me?" box just under your username.

Thanks.....
...This is my first attempt today!! (I am in Germany so I’m on a different time... its morning now...
...after about 3 hours of unsuccessfully trying to reply to my replies last night , I gave up and went to bed.) It was a great shame because it is a good Forum and I was getting some good Help. Unfortunately I wasn’t able to let the people know that had answered me, or take the problem further...
...But it's a new day ( a Holiday in Germany, and I have lots of time. And I see that I have a couple of replies to my Questions on the “Other Languages” forum)... so I look forward to the next couple of hours of hopefully successfully replying!!!
Alan Elston

 

[DocAElstein]

Re: - Text Format in Forums ---o00o---`(_)`---o00o---

...........It worked!!!!!!!!!!

 

[Peter_SSs]

Re: - Text Format in Forums ---o00o---`(_)`---o00o---

...........It worked!!!!!!!!!!

Glad you are happy on that front now.



Now, for the next issue ..

'' When I copy into your message box it always comes out
'' black and white, so I have to start again..
'' Is there a way of getting over this?

.. if you want to display vba code with colours there are two options I would recommend.


1. Use code tags as described in the last line of my signature block. You still have to do any colour, bold etc manually (in the reply window, not where you are composing if composing elsewhere) but it can be displayed like this:

Sub widerColumns()
  Dim c As Long
  
  'Set extra width
  Const Extra As Single = 1.5
  
  For c = 1 To ActiveSheet.UsedRange.Columns.Count
    With Columns(c)
      .ColumnWidth = .ColumnWidth + Extra
    End With
  Next c
End Sub

2. Use the VBHTML Maker - the very last link in my signature block. That allows you to display code that automatically uses the same colours as the vba editor like this or like this.

 

[Scott Huish]

Re: - Text Format in Forums ---o00o---`(_)`---o00o---

I think the op is trying to copy from Microsoft Word and have the formatting remain intact when posting here.