Hello! I would like to have a command button that when clicked, will make a word appear to the row after the cell that contains the word "Stars Gap" in Sheet "Edit"
But the thing is, "Stars Gap" would not always be in the same row but it is always in the same column. Sometimes, it is written in Range B40 or B50 or B63.
Example:
pic1.JPG
Next, when I clicked a command button, a word will appear on the next roq.
pic2.JPG
and when I clicked another command button, another word will appear. They should be on the same row but next paragraph? Because I want the word to appear base on the order in clicking the buttong
pic3.JPG
sometimes, I will click all the command button or only a few of them.
Thank you. Please help
Bookmarks