formating string

Jackeb · Apr 24th, 2002, 03:32 AM

hi,

using this string:

MsgBox "The Program has detected that the last row of data is in Row: " & rowval & Chr(10) & _
"It is likely that you have the wrong settings in the properties field." & Chr(10) & _
"If this is a true reading then this chart cannot be generated. Please do it manualy"

is it possible to change the colour of the "rowval" variable??

is there a way of generally formating the colour of part of a string??

Cheers

Ed

Mudface · Apr 24th, 2002, 04:14 AM

I doubt if this could be done with a messagebox without using API calls as the text displayed will be in the windows standard font for your machine. You should be able to do this with a UserForm though by putting your 'placeholder' text into a label and having the variable appear in a textbox (or another label, even) formatted to a different colour.

Jackeb · Apr 24th, 2002, 06:52 AM

gotya..... thought that it would be a bit difficult!!

Cheers

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 03:32 AM	#1
Jackeb Board Regular Join Date: Mar 2002 Posts: 81	hi, using this string: MsgBox "The Program has detected that the last row of data is in Row: " & rowval & Chr(10) & _ "It is likely that you have the wrong settings in the properties field." & Chr(10) & _ "If this is a true reading then this chart cannot be generated. Please do it manualy" is it possible to change the colour of the "rowval" variable?? is there a way of generally formating the colour of part of a string?? Cheers Ed

Apr 24th, 2002, 04:14 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	I doubt if this could be done with a messagebox without using API calls as the text displayed will be in the windows standard font for your machine. You should be able to do this with a UserForm though by putting your 'placeholder' text into a label and having the variable appear in a textbox (or another label, even) formatted to a different colour.

Apr 24th, 2002, 06:52 AM	#3
Jackeb Board Regular Join Date: Mar 2002 Posts: 81	gotya..... thought that it would be a bit difficult!! Cheers