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

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