I know this is a very simple code and I had searched the net, but don't exactly know how to describe my search, to find the right solution.
I had inserted a scrollbar button and want to use it to insert different text to a cell from an input area, just as using a combo box.
I need several scroll buttons below each other, but they should all get the text from the same input area.
I don't want to use a combo box, because I need to use a conditional formatting at the background and text in the output cell.
The selected text should be able to copy to a different worksheet too - I believe I have the code to do that, but don't think I can do that, if i use a combo box.
And I want to hide the scroll button in the print too, only to see the selected text at the print.
Please look at the attached.
Thank you in advance.
Ib
Bookmarks