Can't get VBA Userform (mac) to write data to worksheets

Hi all,

I'm new to the forum so please be gentle.

I am trying to create a Userform for my mountaineering logbook that will speed up data entry. I have created the form which has a series of btn selecting the activity. These, in turn, specify which fields should be open for data entry. I then have an 'add entry' button which should write the data to a worksheet, again depending on the activity. However, I can't get the 'add entry' button to work.

I've pasted the code below for reference. The problems I have are getting the data to write to different sheets depending on the acitivity selected and getting it to write at all!

Any help would be much appreciated.

Thanks

Please Login or Register  to view this content.