Jump to content


JPL

Member Since 10 Sep 2008
Offline Last Active Jul 04 2017 04:01 PM
-----

Posts I've Made

In Topic: Excel Multiple TextBoxs

04 July 2017 - 03:59 PM

Thanks Galdarian, i'll give your example ago. Yep you are correct, it's listbox not textbox. Basically i have userform with a listbox linked to columns on the Prefill_Values where the columns are titled by names and contain various numbers below them. The userform also has Multiple pages so when i click on a name in the listbox, the information under their names on the Prefill_Values sheet pops into the combobox on the relevant multipages. The columns titled by name are duplicates with different info under each so the info under one name pops into one combobox on one multipage and the same name with different info pops into another combobox on a different multipage. Hope that's not to confusing.


In Topic: Excell Pivot Table Source

05 May 2017 - 03:52 PM

Thanks galdarian; that worked a treat. Thanks again for your help.


In Topic: Excell Pivot Table Source

03 May 2017 - 11:22 AM

Thanks galdarian that seems to have worked but it then brings up the name of the work book, the sheet name and the cell range of source data. Can it be modified so that it only brings up the sheet name?