Copy and paste to different cells

[Testtest]

I have 5 different toggle buttons. Each one is assigned a cell (a1,a2,a3,a4,a5). If clicked once it would select that cell. If would be the same concept as if I were using the Ctrl key if multiple cell were selected. If I clicked more than one of the toggle buttons 2 or more would be selected. Once Im done making my selections I would have a textbox that would enter that data only once across the selected cells. Hopefully Im making sense. It would be the same thing as if I were in Outlook scheduling a couple days off it would select the 2 days and gray them out.

[Leith Ross]

I have 5 different toggle buttons. Each one is assigned a cell (a1,a2,a3,a4,a5). If clicked once it would select that cell. If would be the same concept as if I were using the Ctrl key if multiple cell were selected. If I clicked more than one of the toggle buttons 2 or more would be selected. Once Im done making my selections I would have a textbox that would enter that data only once across the selected cells. Hopefully Im making sense. It would be the same thing as if I were in Outlook scheduling a couple days off it would select the 2 days and gray them out.

Hello Testtest,

You didn't say if your Controls will be on a Form or Direct on the Worksheet. This makes a big difference in how the Controls will be referenced in code. Tell me more about your setup and I can give you a more direct answer.

You can e-mail me at LeithRoss@aol.com