Hi Tom,

Yes Sir.. that did the trick. It was the Initialization command that did
it.

Private Sub UserForm_Initialize()

ComboBox1 = Cells(5, 4)
TextBoxP = Cells(3, 22)
TextBoxFP = Cells(4, 22)
End Sub

Thanks for all your help!!!!!!!


"Tom Ogilvy" wrote in message
...
http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data


http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

--
Regards,
Tom Ogilvy