Dinamically add values in spreadsheet using radio button and check boxes

[mikeyk]

Hello. This is a sample from the spreadsheet which have following columns: Date, Conditions, Day Part and Comments;
Conditions have 3 values: Bad, So-So, OK
Day Part have 4 values: Morning, Afternoon, Evening, Night

I want to dynamically create radio buttons and check boxes which I should use when I enter the data so I can check appropriate radio button and appropriate checkbox for the condition and day part.
Please note that creating form will not work here since I add values for every day.
Like April 26, 27........ It will be constant.
The day part may have multiple values for example afternoon and night.

<colgroup><col width="64"><col width="74"><col width="70"><col width="644"></colgroup><tbody>
[TD="class: xl69, width: 64, align: right"]25-Apr
[/TD]
[TD="class: xl67, width: 74"]So-So[/TD]
[TD="class: xl68, width: 70"]Evening[/TD]
[TD="class: xl70, width: 644"]Short tensions at 1:44 (1 min) of level 2-3.[/TD]

</tbody>

Please let me know if there is a better approach for this task. Thanks
[TABLE="width: 852"]
<colgroup><col width="64"><col width="74"><col width="70"><col width="644"></colgroup><tbody>[TR]

[/TR]
</tbody>[/TABLE]

 

[Deon Venter]

Hi Mike

Could you not add a date (in a textbox?) on the userform, which will allow the user to select the date, and then use check boxes or any other method? You can then write the info to the worksheet in the on_change event, or have a "Update" button once complete?

 

[mikeyk]

Hi Mike

Could you not add a date (in a textbox?) on the userform, which will allow the user to select the date, and then use check boxes or any other method? You can then write the info to the worksheet in the on_change event, or have a "Update" button once complete?

Hi Deon. Thanks for reply. Date is necessary as you probably see it on the sample. By the way in excel the date is automatically filled. The userform won't work in this case same way as update button. I explained that in the initial post. But how to write? I have to add the data every day based on conditions. I was thinking to link radio-buttons and checkbox to the hidden cells in the sheet.

 

[Deon Venter]

I would still use a userform? It could have a textbox that could programmatically update from the last date on the sheet, and the user could change it as required. After doing the required selections on the checkboxes or radio buttons, there could be a command button (you also mention the update button) that could write the chosen options and the date to the worksheet... simply add to the bottom of the list. I unfortunately am not familiar with controls on worksheets, so may not be able to resolve your issue... Sorry.

 

[mikeyk]

Anyone else who is familiar with controls on worksheets? Question is not resolved