I'm a little experienced with VBA but I stucked with the problem of using Checkbox's and I cannot to move on, as its a first time I prepare something using this element of UserForm.
SITUATION: First thing is that I have a table, which more less look like below:
[TABLE="width: 358"]
<tbody>[TR]
[TD] [/TD]
[TD]CLIENT1[/TD]
[TD]CLIENT2[/TD]
[TD]CLIENT3[/TD]
[TD]CLIENT4[/TD]
[TD]CLIENT5[/TD]
[/TR]
[TR]
[TD]Question1?[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Question2?[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Question3?[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Question4?[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col span="5"></colgroup>[/TABLE]
so I have several clients in first row and several questions in a first column.
PROBLEM: I would like to fill in the table with the Initials, which I inserted at the beginning of the macro thru MsgBox, but I would like to do this way:
When I open the macro I'm inserting initials, then I have a UserForm with Checkboxes to select the Clients, which I'm interested, so it should be Client1, Client2 etc. Then I select one client or several clients and press OK and then I have a second UserForm with "Question" checkbox's. I selecting the questions and press OK and then cell related to the Client and Question should be filled in with initials, if not with N/A. Clients and questions could be inserted in hidden sheet if it helps somehow.
maybe you guys could help me with that?
thanks in advance!
SITUATION: First thing is that I have a table, which more less look like below:
[TABLE="width: 358"]
<tbody>[TR]
[TD] [/TD]
[TD]CLIENT1[/TD]
[TD]CLIENT2[/TD]
[TD]CLIENT3[/TD]
[TD]CLIENT4[/TD]
[TD]CLIENT5[/TD]
[/TR]
[TR]
[TD]Question1?[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Question2?[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Question3?[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Question4?[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col span="5"></colgroup>[/TABLE]
so I have several clients in first row and several questions in a first column.
PROBLEM: I would like to fill in the table with the Initials, which I inserted at the beginning of the macro thru MsgBox, but I would like to do this way:
When I open the macro I'm inserting initials, then I have a UserForm with Checkboxes to select the Clients, which I'm interested, so it should be Client1, Client2 etc. Then I select one client or several clients and press OK and then I have a second UserForm with "Question" checkbox's. I selecting the questions and press OK and then cell related to the Client and Question should be filled in with initials, if not with N/A. Clients and questions could be inserted in hidden sheet if it helps somehow.
maybe you guys could help me with that?
thanks in advance!