Hi Guys,
I try to learn VBA and I would like to be able to have the MSGBOX appear with the Cell Value but only when I select a certain range cell or column.
like exemple if I click any cell from column E, so E1, E12, E30, E... the MSGBOX will appear with the value inside that cell. If I click anywhere else in the sheet, A2, C11, D4, this will not open any MSGBOX, is that possible?
for the moment I use this code:
Worksheets("Sheet1").Activate
MsgBox ActiveCell.Value
where is showing any cell in a MSGBOX inside all the worksheet, but I need to have only certain range. also if that is possible, can we add more than 1 column like B and E for exemple if needed later?
thank you for your help
Bookmarks