Dear Forum Members
I need to change the Font and color of one or all of several textboxes if they have been left blank.
I had hoped to do this by refering to a proceedure using code like this:_
Using tbWidth, Me.tbWidth, .tbWidth in the Call line all give error messages.
Please Login or Register to view this content.
The code in Sub ChangeFont works if written directly in the calling procedure
Can anyone help please
Ems
Last edited by Emilysouth; 02-13-2011 at 05:56 PM.
Untested
Post an example workbook if notPlease Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Use no dimension, object or msforms.textbox
'Declarations can spoil more than you like'Please Login or Register to view this content.
Last edited by snb; 02-13-2011 at 10:53 AM.
Dear Roy Uk
Thanks for your post. The change does not work I get the error message
"Type Mismatch"
I will try snb's approach next and if I am still stuck will send a workbook
John
Sadly none of the suggestions worked. I have prepared a workbook with the salient features and my original coding, which does not work.
The code is fired by the "calculate" button. Numbers from the userform are then put into Sheet2 where the calculations are done. The results are then fed back to the userform.
To guard against faulty calculations and Div by 0 problems I want to use the Sub RedText
This also alerts the user as to which textbox he has missed.
Ems
I doubt your observations:
Your code has the following faults:
MyTextBox.Font=14 should be .Font.size=14
MyTextBox.ForeColour=vbRed should be .Forcolor=vbred
I hope you didn't continue/repeat them
Please Login or Register to view this content.
snb
Thanks for your input. The code faults you found were typos as i couldn't just copy and paste.
The actual code was as you advised, American spelling and all.
I will be trying again later tonight and will let you know how I get on tomorrow.
Ems
Hello EMS,
This macro will mark any TextBox that is empty with the 3 asterisks in red font.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks