link a page in a multipage userform to a worksheet

    Hi,
    I would like to link each page in a multipage userform to different worksheet. How would I go about doing this?
    I have 4 worksheets that are order forms and I created the multipage userform to aid users to fill out the order forms and place orders. I have been searching and trying different change events but, no luck in getting it to work.
    Thank you,
    Steve

    Re: link a page in a multipage userform to a worksheet


    You could have a button that opens the said workbook using something like this

    Code
    Sup Open_Exist()
Workbooks.Open "C:\WorkbookName.xls"
end sub


    or


    Code
    Workbooks.Open Filename:="C:\WorkbookName.xls"

    Re: link a page in a multipage userform to a worksheet


    Quote from StevegSmith;796286

    Hi,
    I would like to link each page in a multipage userform to different worksheet. How would I go about doing this?
    I have 4 worksheets that are order forms and I created the multipage userform to aid users to fill out the order forms and place orders. I have been searching and trying different change events but, no luck in getting it to work.
    Thank you,
    Steve


    Thank you! I will give it a shot. Thank you for taking the time to look at my problem:)
    Steve

    Re: link a page in a multipage userform to a worksheet


    You have posted this question on Experts Exchange and I answered it there.


    Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!


    Read this to understand why we ask you to do this

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login