Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
User form
Hi,
I've created a form that inputs a number into a field but rather than just say the number I want it to say "approximate hours (NUMBER HERE) charged at $88 per hour" Heres the VB code so far, I just don't know how to have the input number and text combined. Private Sub txtdesignhrs_Initialize() txtto.Value = "" End Sub Private Sub cmdOKdesign_Click() ActiveWorkbook.Sheets("Quote Builder").Activate Range("B24").Select ActiveCell.Value = txtdesignhrs + txtnobox Unload Me End Sub Thanks for you help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
User form
"Your text here " & cstr(<number value) & " text"
cstr - convert some expression into string hope this help. Leung "JonathanW" wrote: Hi, I've created a form that inputs a number into a field but rather than just say the number I want it to say "approximate hours (NUMBER HERE) charged at $88 per hour" Heres the VB code so far, I just don't know how to have the input number and text combined. Private Sub txtdesignhrs_Initialize() txtto.Value = "" End Sub Private Sub cmdOKdesign_Click() ActiveWorkbook.Sheets("Quote Builder").Activate Range("B24").Select ActiveCell.Value = txtdesignhrs + txtnobox Unload Me End Sub Thanks for you help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form | Excel Discussion (Misc queries) | |||
User form | Excel Discussion (Misc queries) | |||
Help On User Form | Excel Discussion (Misc queries) | |||
user form | New Users to Excel | |||
User Form Still Trying | New Users to Excel |