Can you change the forecolor of various portions of text within a userform textbox?

[rizzo93]

My users must follow a certain format when entering a project summary so that all summaries look consistent from a formatting perspective.

For example, I'm looking for "3/4/19", NOT "03/04/19" or "3/4/2019". Another example is, "Procurement is required" NOT "Procurement must be done". Again, just making things consistent across all user input.

Using formulas within a worksheet, I'm calculating where the problem spots are. I then provide a summary of what needs to be corrected. But I am thinking of taking it one step further by colorizing the problem errors within a textbox to make them more prominent (my team is very visual and doesn't like to read).

So if my textbox starts out with forecolor "vbwhite" and backcolor "vbgrey", I have a checkbox in the userform that will turn all of the text vbgreen and the backcolor to vbblack. But I just want it to make things like the wrongly formatted "03/04/19" to be vbgreen while changing the rest of the text to something dimmer. And if there's another problem spot, that would also be vbgreen.

Ultimately, I'd like one subroutine to go through and find the problem areas, and then call another subroutine to make just those areas a different color.

Can this be done without needing a degree in rocket science?

 

[rizzo93]

if your formulas can identify the problems, or you can specify/articulate the details via rules/logic, then that means some program code could be written to do the fix-ups

hard to know how involved that would be, but it is hopefully not a big deal. so the users can enter the data just like they do now & the code would change it to what is acceptable

should be easier for everyone? a win-win

just needs some further explanation of the setup and details for people [edit: forum users] to advise (on exact details of the solution/code)

Thanks, Fazza. With some exceptions, my intent is for the content providers to correct their data themselves. I'm just pointing out what they need to correct. But I do agree there must be something more I can do to get my corrections across to them.

 

[DanteAmor]

Another interesting option, DanteAmor. Thanks!

Oh and please tell me how you got an image posted into this thread.

Youre welcome.

I put the image in another forum that allows the insertion of images, I copy it and paste it here.

 

[Jon Peltier]

I already asked, where is the user typing their entries?

If they're typing into the form, you can write code that corrects it when they leave the textbox. Or if there are only certain choices available, put them in a dropdown, to save the user typing and save you validation.

If they're typing into cells, use a number format for the date format you want, and use data validation.

 

[DanteAmor]

Another option to enter dates is to add a date control as DTPicker, that way the date will always be a correct date.

 

[rizzo93]

I already asked, where is the user typing their entries?

If they're typing into the form, you can write code that corrects it when they leave the textbox. Or if there are only certain choices available, put them in a dropdown, to save the user typing and save you validation.

If they're typing into cells, use a number format for the date format you want, and use data validation.

Jon,

They're entering their information into an online platform. I then export that information to do further processing. So there's no way to do on-the-fly editing at the time of data entry. There are a few scenarios when I can correct some things when I know what to look for, but the majority of my work is to identify the problem spots after the fact and then notify them to make the necessary corrections.

 

[rizzo93]

Another option to enter dates is to add a date control as DTPicker, that way the date will always be a correct date.

True, but I didn't give a clear picture of how the whole process works from data entry to me processing what I receive. So, sorry about the confusion.

 

[DanteAmor]

Do not worry, now you have several ideas for your process