Error in showing user form

[ashokkumarkolla]

Dear sir,

I am trying to enter data with the help of user form named "RFI".

I had prepared the user form and created a command button named "RUN" to show the user form "RFI" and assigned following code.

Private Sub CommandButton1_Click()

rfiuserform.Show

End Sub

&

While clicking the "RUN" button, it says "Run time Error '424', Object Required"

Can Some body guide me.

Attached the File for reference.

Thanks
Ashok.

 

[NARAYANK991]

Hi ,

Your usage is wrong in all cases.

Since RFI is the name of the userform , the usage should be :

RFI.Show

Similarly , in all of the below :

DATEBOXTEXTBOX.Value = ""
DESCBOXTEXTBOX.Value = ""
FROMBOXTEXTBOX.Value = ""
LENGTHBOXTEXTBOX.Value = ""
REMARKSTEXTBOX.Value = ""
RFINOTEXTBOX.Value = ""
SIDEBOXTEXTBOX.Value = ""
STATUSLISTTEXTBOX.Value = ""
TOBOXTEXTBOX.Value = ""

DEPARTMENTLISTBOX.Clear

With DEPARTMENTLISTBOX

the highlighted portions should be removed.

When referring to any object , the name of the object is sufficient.

Narayan

 

[ashokkumarkolla]

@NARAYANK991
thanks for your reply.

I had corrected the mistakes, but the following code is giving mistake.

PrivateSub CommandButton1_Click()

rfi.Show

EndSub

Uploaded the modified file. Can you please check.
Note: I am using Excel 2016
Thanks
Ashok

 

[NARAYANK991]

Hi ,

The problem was this line of code :

REMARKS.Value = ""

It should read :

REMARKSBOX.Value = ""

Narayan

 

[ashokkumarkolla]

@NARAYANK991

it worked.

thanks for your reply.
Ashok.