O
oli merge
Hi,
I have some listboxes with multiselect enabled on a form I am working on. I
want them to default to all options checked, but let the user alter them and
save the changes, send it to me and me still be able to see what they have
changed.
I currently have a macro that sets all values to checked on the workbook
open event, which is no good because any changes the user makes are lost when
I reopen it.
I have tried using the linkedcell property to set them to a range, but dont
really understand how to do this, the values of the range seem to have no
effect on the values of the checkbox.
Any suggestions?
Thanks.
I have some listboxes with multiselect enabled on a form I am working on. I
want them to default to all options checked, but let the user alter them and
save the changes, send it to me and me still be able to see what they have
changed.
I currently have a macro that sets all values to checked on the workbook
open event, which is no good because any changes the user makes are lost when
I reopen it.
I have tried using the linkedcell property to set them to a range, but dont
really understand how to do this, the values of the range seem to have no
effect on the values of the checkbox.
Any suggestions?
Thanks.