I have a dialog box that I want to launch from any row in my table. I might also be in any column.

How would I write my data back to the row I am launching from and in specific columns?

Here's what I have at the moment:

'Mail Services
If chkMailCenter Then Worksheets("Opportunities").Range("AJ15").Value = "True"
If chkSecureMail Then Worksheets("Opportunities").Range("AK15").Value = "True"
If chkShipping Then Worksheets("Opportunities").Range("AL15").Value = "True"
If chkMailComputer Then Worksheets("Opportunities").Range("AM15").Value = "True"
If chkMailOther Then Worksheets("Opportunities").Range("AN15").Value = "True"

As you can see, my code always writes back to row 15. I want to be able to write to specific columns based on the row I started in when I launched the dialog box.

--zbert