Thread: User form
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JonathanW JonathanW is offline
external usenet poster
 
Posts: 18
Default 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