p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

vba_excel thread: Text Box Formatting


Message #1 by "Ian" <Ian.Watson@A...> on Mon, 7 Jan 2002 22:51:26
Am pretty new to programming Excel VBA, so think this may be an easy fix.

Trying to format several Text Boxes within a UserForm whose Control Source 
is linked to ranges in the spreadsheet, so that when user types in the 
box, it automatically formats to "0.00%" for instance.

Have tried palying around with MyStr and Format commands on the click 
command, but no success so far.

Guidance/ tips would be much appreciated.


  Return to Index