• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Userforum.show not working

phanikumar.bs

New Member
I am facing a problem while running a Macro, the userforums.show is not working.

My code :-


'Clears the invoice sheet

Private Sub CmdNewInv_Click()

With Sheet2

'Clear previous invoice details

[D15:H16, D17:H17, F18:H18, C20:D20, G25:H27, H13, G20:H20, B25:D27, A34:D34, E34, E40, A42:H42].ClearContents


'INCREMENT THE INVOICE NUMBER

[C13] = [C13] + 1


'open userform

frmNewInv.Show


End With

End Sub


Please help me as i was not able to find out whats the problem.

If you require any more information please let me know.
 
Hi Phanikumar ,


Have you named your user form frmNewInv ?


By default , the first user form is UserForm1 ; you need to go to the Properties Window for the Form , and change its name.


Narayan
 
Back
Top