Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
I have a multipage userform (8 pages)that will have 12 questions on
each with a yes/no chkbox. Each chkbox is named yes1, yes2 etc. When a user ticks yes, a value of 1 is added onto a hidden sheet named "Chart". Now the problem is once I close the workbook the previous ticks are gone. I use me.hide and this works while the workbook is open. How do I reference the previous state of the userform? First post and just new to the excel experience. Thanks Allan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Assuming that you save the workbook, all you need to do is read the data from
the sheet when th euserform is initialised...if your check boxes are linked to th ecells, then this will be automatic. If you're not saving the workbook, then you need to export the results so that they can be read back when the workbook is re-opened. "Alro" wrote: I have a multipage userform (8 pages)that will have 12 questions on each with a yes/no chkbox. Each chkbox is named yes1, yes2 etc. When a user ticks yes, a value of 1 is added onto a hidden sheet named "Chart". Now the problem is once I close the workbook the previous ticks are gone. I use me.hide and this works while the workbook is open. How do I reference the previous state of the userform? First post and just new to the excel experience. Thanks Allan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Hi Allan,
When you reopen the file, you could repopulate the UserForm by looking at the values that you have saved on the "chart" sheet. i.e. something like if cell.value=1 then chkbox.value=true else chkbox.value=false end if You would need some logic here to connect the names of the chkboxes and the location of the "1" cells on the chart sheet. Regards Andrew excelthoughts.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
How do I link the cells? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Thanks for helping. I'm on the right track now I think.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
User Form Help | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming |