well i tried with the othe options as well but i get the same result here also.
Let me describe the scenarios:
When i select a cell in an excel file, a form suppose to show up which contains a tabcontrol with some tabpages.but all the tabpages has to be hidden since i can't use tabpages.hide()...
actually it works with "for each" loop using tabpages.remove.
but the point is when i put the code in form_load subroutine then it works.Again if I write the code in worksheet_selectionChanged event then it stops working.
hi,
I have an event called "worksheet_selectionchanged" which occurs when a range/cell is selected in an excle file.When the event is triggered, all the tabpages in a tabcontrol should be removed.
The code is given below:
Private Sub myWorksheet_SelectionChange(ByVal Target As Excel.Range)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.