DATA VALIDATION INPUT MESSAGE
 

Thanks for reading this post.

Is there a way to do the following (in Office 2003)?

1 Change the background colour of the input message window
2 Change the text colour of input message
3 Change the text size and font of input message

Thanks in advance

DATA VALIDATION INPUT MESSAGE
 

j,

Those are all determined by Windows settings. You would need to use a custom form fired by the
selection change event to customize any of those things.

HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...
Thanks for reading this post.

Is there a way to do the following (in Office 2003)?

1 Change the background colour of the input message window
2 Change the text colour of input message
3 Change the text size and font of input message

Thanks in advance

DATA VALIDATION INPUT MESSAGE
 

Bernie,

Thanks for reading and responding to my post.

Appreciate if you could kindly elaborate your response.

Thanks in advance

Kind regards

Preman





"Bernie Deitrick" wrote:

j,

Those are all determined by Windows settings. You would need to use a custom form fired by the
selection change event to customize any of those things.

HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...
Thanks for reading this post.

Is there a way to do the following (in Office 2003)?

1 Change the background colour of the input message window
2 Change the text colour of input message
3 Change the text size and font of input message

Thanks in advance

DATA VALIDATION INPUT MESSAGE
 

Preman,

Which part needs elaboration? Windows settings, or using the selection change event and a userform?

HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...
Bernie,

Thanks for reading and responding to my post.

Appreciate if you could kindly elaborate your response.

Thanks in advance

Kind regards

Preman





"Bernie Deitrick" wrote:

j,

Those are all determined by Windows settings. You would need to use a custom form fired by the
selection change event to customize any of those things.

HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...
Thanks for reading this post.

Is there a way to do the following (in Office 2003)?

1 Change the background colour of the input message window
2 Change the text colour of input message
3 Change the text size and font of input message

Thanks in advance

DATA VALIDATION INPUT MESSAGE
 

I truly appreciate your assistant.

I would like to have both elaborated. I mean how to achieve my requirement.

Preman



"Bernie Deitrick" wrote:

Preman,

Which part needs elaboration? Windows settings, or using the selection change event and a userform?

HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...
Bernie,

Thanks for reading and responding to my post.

Appreciate if you could kindly elaborate your response.

Thanks in advance

Kind regards

Preman





"Bernie Deitrick" wrote:

j,

Those are all determined by Windows settings. You would need to use a custom form fired by the
selection change event to customize any of those things.

HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...
Thanks for reading this post.

Is there a way to do the following (in Office 2003)?

1 Change the background colour of the input message window
2 Change the text colour of input message
3 Change the text size and font of input message

Thanks in advance

DATA VALIDATION INPUT MESSAGE
 

In the VBE, add a userform to your project, and make sure the name is UserForm1. Add a text box with
your message, and change the colors, fonts etc any way you want. Add pictures. Whatever. Add a
sinlge commandbutton, double click the commandbuttons and add "Unload Me" to the procedure that
appears:

Private Sub CommandButton1_Click()
Unload Me
End Sub

Add this to a regular codemodule:

Sub ShowMessage()
Load UserForm1
UserForm1.Show
End Sub

and add this to the sheet's codemodule (assuming your message should appear for cell A3):

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("A3")) Is Nothing Then Exit Sub
ShowMessage
End Sub

Then select cell A3, and see what happens.


HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...

I truly appreciate your assistant.

I would like to have both elaborated. I mean how to achieve my requirement.

Preman



"Bernie Deitrick" wrote:

Preman,

Which part needs elaboration? Windows settings, or using the selection change event and a
userform?

HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...
Bernie,

Thanks for reading and responding to my post.

Appreciate if you could kindly elaborate your response.

Thanks in advance

Kind regards

Preman





"Bernie Deitrick" wrote:

j,

Those are all determined by Windows settings. You would need to use a custom form fired by
the
selection change event to customize any of those things.

HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...
Thanks for reading this post.

Is there a way to do the following (in Office 2003)?

1 Change the background colour of the input message window
2 Change the text colour of input message
3 Change the text size and font of input message

Thanks in advance

DATA VALIDATION INPUT MESSAGE
 

I haven't used VBE for while. It may take time for me to try out the
solution. Nevertheless, I've now got an idea on how to go about it.

I truly appreciate your kind assistance.

Thanks a lot.

Kind regards

Preman

"Bernie Deitrick" wrote:

In the VBE, add a userform to your project, and make sure the name is UserForm1. Add a text box with
your message, and change the colors, fonts etc any way you want. Add pictures. Whatever. Add a
sinlge commandbutton, double click the commandbuttons and add "Unload Me" to the procedure that
appears:

Private Sub CommandButton1_Click()
Unload Me
End Sub

Add this to a regular codemodule:

Sub ShowMessage()
Load UserForm1
UserForm1.Show
End Sub

and add this to the sheet's codemodule (assuming your message should appear for cell A3):

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("A3")) Is Nothing Then Exit Sub
ShowMessage
End Sub

Then select cell A3, and see what happens.


HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...

I truly appreciate your assistant.

I would like to have both elaborated. I mean how to achieve my requirement.

Preman



"Bernie Deitrick" wrote:

Preman,

Which part needs elaboration? Windows settings, or using the selection change event and a
userform?

HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...
Bernie,

Thanks for reading and responding to my post.

Appreciate if you could kindly elaborate your response.

Thanks in advance

Kind regards

Preman





"Bernie Deitrick" wrote:

j,

Those are all determined by Windows settings. You would need to use a custom form fired by
the
selection change event to customize any of those things.

HTH,
Bernie
MS Excel MVP


"jpreman" wrote in message
...
Thanks for reading this post.

Is there a way to do the following (in Office 2003)?

1 Change the background colour of the input message window
2 Change the text colour of input message
3 Change the text size and font of input message

Thanks in advance