Search code examples
excelvbauserform

How do I open UserForm in the active cell?

I've got a UserForm that I'd like to start when I open the workbook and also in the range below. Also, always it has to be in the same place no matter what screen or computer it is. But how do I do that?

I'll use a userform, because I will use multiple columns in the list box.

Range ("C35:K44"): https://i.sstatic.net/wjGIB.jpg

Thanks!

Solution

  • Actually I managed to use Activex Listbox, so I got as many colums I want and it's fixed in the range I want as well.