I've learned so much from this forum. Thanks guys. Well here's a problem that I found some answers and codes, but when I pasted the codes to my file, there's nothing happened.
So, I want to have a text box with several buttons on it shown in the spreadsheet, and when I scroll up and down, and add/delete data, the box should always be visible. It's something like the side navigation bar of this forum. I followed RoyUK's method from this thread: http://www.excelforum.com/excel-gene...-text-box.html, and pasted the following code to module 1, while nothing happened.
I don't know where did I do wrong, and I don't have any VBA knowledge.
I appreciate for the help! Thanks so much!
Bookmarks