Ginjaninja
New Member
- Joined
- Jul 24, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi there
i was wondering if someone can point in the right direction, i am a newb when it comes to VBA so please be very basic if you reply
i am creating a daily planner for my partner for her very small business, i have made a drop down list using data validation which ok, but the problem was that the the list is quite long and i wanted it so that she could just type the first letter of a name and the choices would appear, so I googled it and found how to add a combo box and use some VBA code. I thought this may be applied to every sheet as i have a sheet for every week in the year but unfortunately it doesn't.
I have tried applying the code to every sheet and copying the combo box to some of the sheets individually but is does not like it as the combobox name changes and the code gives me an error.
is there anyway this could be done and if so i would appreciate if someone could help me solve it.
Thanks in advance
The NiNja
i was wondering if someone can point in the right direction, i am a newb when it comes to VBA so please be very basic if you reply
i am creating a daily planner for my partner for her very small business, i have made a drop down list using data validation which ok, but the problem was that the the list is quite long and i wanted it so that she could just type the first letter of a name and the choices would appear, so I googled it and found how to add a combo box and use some VBA code. I thought this may be applied to every sheet as i have a sheet for every week in the year but unfortunately it doesn't.
I have tried applying the code to every sheet and copying the combo box to some of the sheets individually but is does not like it as the combobox name changes and the code gives me an error.
is there anyway this could be done and if so i would appreciate if someone could help me solve it.
Thanks in advance
The NiNja