Formatting fields in User Forms

Hi,

I have a question that I have not been able to figure out. I am trying to change the formatting of how my fields in my user form is shown (i.e. just the estethic view before the form is recorded). Is this possible? E.g. how would I change a forms view with data 1,200,565 to show as $1,200,565 instead of just 1200565? I am trying to tweak the code, but have been unable to succeed so far...

Any tips are greatly appreciated!!

Thanks,
Max

I have not played around with forms much.

The only way I know on how to do it is in code

Please Login or Register  to view this content.

Thanks for your quick reply. I am still unable to see the new format in the user form though. I have so far tried to alter the code under the "UserForm_Initialize" section, which is also where I populate the various lists for my combination boxes, etc.

Hi DominicB,

Thank you for the zip file. It works well for showing the format when pushing the button, although what I was looking for was a way to automatically see the field update in the specific format when "tab-ing" to the next field. That way its easier for the user to see the exact dollar value (often in billions) before hitting the ok button.

Thanks,
Max

I used your file and was able to modify it to my spreadsheet, and it finally works. Basically, I just created a "Private Sub textbox_Change()" section.

Thanks again!

Max