Hi have 2 macros in a sheet, the first spell checks, the 2nd allows multiple dropdowns in a cell/column. It appears that the sepll check stops the multiple dropdown macro from working. I stuck the 2 macros together from ones I found online. The spellcheck is about the best I found to work code is below, wondering if anyone has any ideas why one disables the other?
Please Login or Register to view this content.
Last edited by 6StringJazzer; 11-06-2020 at 07:33 PM. Reason: Moved from Excel General
Don't you "feel guilty" on account of "cheating" a VBA compiler with colons ?
Hi Porucha
thank you for taking the time to reply. Are you saying removing the colons and doing something with the areas you highlighted will help? As I say I got these pieces of code separately from the net, the drop-down code was I think from TrumpExcel. They both work without fault one their own in different workbooks but put together there seems to be a conflict as though the spellcheck is preventing the dropdown macro from working, which line is it that you are suggesting I change and/or what to? Many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks