Using option buttons to allocate data in one of two places! Help!

[afrabat]

Never worked option buttons so I would like to see how it is coded.

This macro is called customer. It is for adding a new customer to the list. I have a macro going already and it does a basic job. However, what I would like to do is add two option buttons (already added) and code them to put the data in one spot or another depending which option button is activated. I have never used option buttons so I'm not sure how this would be coded.

The data is on the customer list sheet.

When entering a new customer with the customer macro I would like to be able to press residential and have it go to that column. Or press Commercial and have it go to that column.

Any help would be greatly appreciated and I would add reputation for it!

Here is the latest version of the workbook.

[humdingaling]

slight amendment to your Lastrow code
see attached file

Please Login or Register  to view this content.

only thing to be careful of your offset with merged cells
if you have lines in there already you wont notice it
will only effect your first line