bookmark value depending on how many checkboxes are checked

[sessionone]

Hi all,

I'm looking for some tips on how to change bookmark string depending on how many checkboxes are checked on a userform.

I have 3 checkboxes: let's say "one", "two", "three". If "one" is checked then the bookmark string is "one", if "two" is chekced then the bookmark is "two" etc. But how can I combine them, so that if "one" and "two" are checked, the bookmark is "one, two".

I am using Select Case, but I can't get it working properly.

Please help.

sessionone

 

[macropod]

Hi sessionone,

VBA questions should be posted in the vba forum:

http://www.tek-tips.com/threadminder.cfm?pid=707

When doing so, please include the code you're having problems with.


Cheers
[MS MVP - Word]

 

[sessionone]

Appologies

 

[SkipVought]

I thnk that macropod intended to reference forum707.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[macropod]

Hi Skip,

Apart from the hyperlink format that appears in the post, what the difference? For me, the end result of following the hyperlink looks the same ...


Cheers
[MS MVP - Word]

 

[SkipVought]

macropod,

Ahhhhh. So it does. My wrong assumption!

And my sincere apologies.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[sessionone]

thanks guys, all is sorted. used if for all possible situations. as in, if one = true and two = false, then "one", if one = false and two = true, then "two", if one = true and two = true then "one, two".

thanks for your time,
sessionone