Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object Required Error
Hello. Anyone see a problem with the below code? A button calls the
Userform. The enter button on the user form calls the Private sub, and if the if statement is validated, the private calls the Sub Write_Data. Is the problem with variables across sub modules? If UserForm1.Caption = "New Project" Then With Worksheets("Data") Set newRow = .Cells(Rows.Count, "F").End(xlUp).Offset(1, 5) End With Write_Data Else Sub Write_Data() newRow.Offset(0, 4).Value = NewBase.TextBox1.Text End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Object required - run time error 424. | Excel Programming | |||
runtime error ....object required | Excel Programming | |||
object required error message | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming | |||
error 424 - Object Required | Excel Programming |