I have created a Userform in Excel and have never used Visual Basic before but through the help of these forums, not doing too bad.
Issue 1) When writing the data to my worksheet for CheckBox info it is stored in the worksheet as true or false. I would prefer it to store as the checkbox title. My checkboxes are for weather and I would rather fog, snow, rain, etc be stored as opposed to true or false.
Issue 2) I have code for making sure a value is numeric to store phone numbers but you have to enter 1112222 without a hyphen is there a better way to do this or should I remove the numeric requirement.
Issue 3) Now I need some code for a Goto Record and and Edit record Command Button.
Any help would be appreciated. I will upload exisiting code.
Issue 4) Any formatting suggestions for 24 hour clock time format, I took out what I had as it stalled every time I ran it.
Bookmarks