Forum Discussion
drop list with check box
I think it didn't work because excel stopped macro functions
You're right, that's not what I want. I attached a file by mistake, see the correct attachment. The problem is that it needs an external source. It must be downloaded. Can we do the same thing without that?
KuTools is a commercial product, but the article in my previous reply explains how you can simulate a combo box with check boxes by using a list box. It does not require downloading anything (but it works on Windows only, not on Mac)
- if you just for fast entry,how about a plugin?
like auto hot key
https://www.autohotkey.com/
https://club.excelhome.net/forum.php?mod=viewthread&tid=567518&extra=&mobile= - You're right it doesn't work, the problem lies in the complexity of the macro, I tried it and it on gogle sheet but didn't work until I tried it on Excel online and it didn't work but what is the best option to apply it to Excel with out macro,After all the experiments I'm going to empty the dropdown list with separate columns and cancel the drop down list except If there is a solution
if you want an online form,I am afraid excel is not the best choice for customize input.
A dynamic web page looks better solution.KuTools will not work on Google Sheets, nor will the method using an ActiveX list box. That works only in the desktop version of Excel for Windows.
I have no experience with Google Sheets, so I have no idea if what you want is possible there.
The problem is that I will be sharing the file with a number of interested people via Google Sheet in order to have a live update of the file. If I download Kutools, will it work correctly, or will there be errors?
