Excel VBA Forms Part 11 - Check Boxes

preview_player
Показать описание


By Andrew Gould

Рекомендации по теме
Комментарии
Автор

I am trying to add several checkboxes to a userform that when checked with enter a date into the cell i called.
1. I am not sure how to set the checkbox that when True equates to Date.

Current code:
sub checkbox1 _ change()
If checkbox1.value is true then
.value = Date
Else
.value = ""
End If
End Sub

2. When I transition to edit mode and search in my worksheet it changes all the dates to the current date. So I am not sure how to hard code the dates so when i uses the userform to make edits it wont change the dates.

So i guess my question is how do i hard code dates when a checkbox is checked?

erikainks
Автор

How can I get my Checkbox value to equal something other than "True/False" for example "Good/ Not good"

erikainks
Автор

Thanks. My form is getting quite large now. lol

krn