Dear Experts,
I am using the below script in the combobox for go to the selected worksheet and hide non active worksheets but some time it triggers automatic calculation and go to the selected worksheet and sometimes not and incase if not triggers automatically then i do click on calculate now. Is it possible to fix this error.
Request to you kindly do help me out.
Please Login or Register to view this content.
Many thanks and kind regards,
Neilesh
Last edited by Neilesh Kumar; 04-27-2018 at 01:32 AM. Reason: completing the Info
With just the code it is difficult to tell since I do not have the rest of the information but I suggest you look at the code and add the text in RED
Please Login or Register to view this content.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Or try maybe this code:
1. UserForm1 module:
Before you run the macro, hide sheets except one with any name (of course, one in the names range of your sheets).Please Login or Register to view this content.
Dear Experts, The combobox is still the same after opening the workbook it works for 2 or 3 changes then it stucks then for every selection change i need to click on calculate now. Please help me.
???
A small change in the code:
(see attachment)
Please Login or Register to view this content.
Hi porucha vevrku, Thank you for your support. I do have combobox with list of 22 files for go to the selected worksheet and hide the rest but the provided solution here is for the userform. So do i need to create the userform for the 22 worksheet list.
Yes well you can dynamically add any number of worksheets, just populate the userform on opening with all the available worksheet names?
And the range is given for combo box from sheet2 cell AC2:AC24.
Dear expert based on provided range criteria can you please create a sample workbook with userfom and script .
If you use your imagination you could do it yourself too
The way this usually works is that YOU, the OP, provides a sample workbook with typical data and expected results together with all your code. You shouldn't expect anyone else to do that for you (imagination or not). Kudos to Keebellah for having a go.Dear expert based on provided range criteria can you please create a sample workbook with userfom and script .
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Dear Expert TMS, as I am not familiar with the VBA so that is only reason to create a sample workbook with the script because I was completely not getting how to use userform in workbook as dropdown for selecting the worksheet.
I do apologise for the same. I would surely take care of henceforth.
1.Originally Posted by Neilesh Kumar
From "ac2" to "ac24" there are 23 sheets
2. Continuing with Keebellah's corrections to my corrections to your corrections to your corrections of our corrections, etc.
... : ( ... : | ... : () ... : ) ... : )) ... :
You have now enough code, to do something yourself ... : ) ...
Thank you so much dear experts for your precious and valuable support.
Last edited by Neilesh Kumar; 04-28-2018 at 12:52 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks