Checkboxes If Else condition..

**siobeh** · 04-24-2014, 03:15 PM

Hello,

I have a 2 userforms:

Userform1: List of Names
Userform2: List of Hobbies

I have a code for the "DbClick" event for every checkboxes wherein it will select a specific cell.

Sample is:

Please Login or Register  to view this content.

For every activecell, it will execute the below code:

Please Login or Register  to view this content.

My problem is that, when I select "Roberto" or "Gio" or "Kelly" or "John" though it will select their specific ranges, the "Hobby" is not populating in the activecell.
I have attached my workbook.

Thanks in advance Gurus!

**siobeh** · 04-24-2014, 04:21 PM

Anyone can help me on this please?

**stnkynts** · 04-24-2014, 04:27 PM

I was trying to figure out your flow but it was a little challenging (I would have set it up differently but I tried to work with the way you had it set up). I assumed that you will only have 1 checkbox checked at a time. Here is the code for the 2 userforms

UserForm1:

Please Login or Register  to view this content.

Userform2 (actually calling Subroutine names):

Please Login or Register  to view this content.

**siobeh** · 04-24-2014, 04:56 PM

Hi stnk,

I've trying to adopt the code that you've provided by I'm getting an error "Invalid Next control variable reference"

I have this module:

Please Login or Register  to view this content.

**siobeh** · 04-24-2014, 05:11 PM

Hi stnk,

I've figured it out: I've missed type

Please Login or Register  to view this content.

insted of

Please Login or Register  to view this content.

What if the format is like in the attached file? how can i amend the code so it will suite up? It still the same like the other, but this this time, it will not based on the names but based on the merged center cells.

For example: A2:A4, you will see that it will merged in Column B.

Checkboxes If Else condition..

LinkBack

Thread Tools

Rate This Thread

Display

Checkboxes If Else condition..

Re: Checkboxes If Else condition..

Re: Checkboxes If Else condition..

Re: Checkboxes If Else condition..

Re: Checkboxes If Else condition..

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] IF the condition of gender is met AND the condition of age is met subtract this number

[SOLVED] Help for if condition formula result only either hit or miss from mulitple condition

Mutiple Checkboxes using SetCheckBoxes Function to change state of several checkboxes

Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro

multi condition format? lookup and date condition valid for.

Bookmarks

Bookmarks

Posting Permissions