VBA Tabstrip - store values in Excel

  • Hi There


    Am new to Excel VBA, i create a userform to capture customer data and populate excel.


    My logic


    Tabstrip1 with multiple tabs


    Each tab has same set of objects like text boxes , list boxes. - Ex : textbox1, listbox1


    I assumed value i enter in textbox1 will be applicable only to tab1, but what i realized is when i enter textbox1 value in tab1, the same value is populated in all tab2 i.e tab2, tab3 etc.


    Is there a way to restrict the values i enter to only to that specific tab? so that i can enter different values in each tab and get them store in excel in multiple rows.


    Thanks

  • Re: VBA Tabstrip - store values in Excel


    You need to use a Multipage control, instead of a tabstrip control. Google Multipage V Tabstrip, or look here:


    http://www.ozgrid.com/forum/showthread.php?t=69275


    Regards
    ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

Participate now!

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