PDA

View Full Version : User Form Won't show



austenr
04-20-2007, 01:21 PM
Hi,

I modified a userform by adding extra text boxes and labels and now the user form wont show. If you click on the "Instructions" tab and click the button, you get an error saying the form cant be found but in the VBE window it is there. Workbook is attached. Thanks

mdmackillop
04-20-2007, 01:36 PM
You can't code for textboxes that don't exist on the form
Sub GetData()
With Me
.TextA = Range("DataBase").Cells(iRowNumber, 1)
.TextB = Range("DataBase").Cells(iRowNumber, 2)
.TextC = Range("DataBase").Cells(iRowNumber, 3)
.TextD = Range("DataBase").Cells(iRowNumber, 4)
End With
End Sub

austenr
04-20-2007, 01:42 PM
I knew it was something pathetically easy. This is the result of trying to multi task on a Friday. :bug: :bug: Thanks for pointing that out my friend.