Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone,
I have that piece of code to set the focus of a userform to a certain sheet and cell but problem is I keep on getting a runtime error '424' Dim selRange As Range Set selRange = Application.Selection 'ecDisplayLocationRE.Text = "'" & selRange.Worksheet.Name & "'!" & selRange.Address bpDisplayLocationRE.Text = "'" & selRange.Worksheet.Name & "'!" & selRange.Address 'ecDisplayLocation.SetFocus bpDisplayLocation.SetFocus Thks for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Runtime error '424': Object Required | Excel Discussion (Misc queries) | |||
runtime error 75 when I run the application for second time | Excel Programming | |||
"Microsoft Visual Basic runtime error '424' object required". | Excel Worksheet Functions | |||
Runtime error 1004- application defined or object defined error | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |