Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The autofilter is disable using the userform
My problem is with the autofilter
What is my problem? when i use the find button in a userform created in VBA, the autofilter is disable automatically in the worksheet without my intervention the close button disable too the autofilter in the worksheet. What is my question? How i can Troubleshooting my application to never disable the autofilter when the users use the userform especially the find button and the close button |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
The autofilter is disable using the userform
i post here my code :
http://www.mrexcel.com/forum/showthread.php?t=393635 I too long to post here but there you can download or only see the code. Thanks. "Patrick Molloy" wrote: I'm not sure what the issue is. we really need to see your code using the FIND method in a userform does not have any direct affect on an automatic filter. (Excel 2003) "Joseph Pagan" wrote in message ... My problem is with the autofilter What is my problem? when i use the find button in a userform created in VBA, the autofilter is disable automatically in the worksheet without my intervention the close button disable too the autofilter in the worksheet. What is my question? How i can Troubleshooting my application to never disable the autofilter when the users use the userform especially the find button and the close button |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
The autofilter is disable using the userform
delete this:-
If Sheet1.AutoFilterMode Then Sheet1.Range("A7").AutoFilter which is the last code line in sub Button8_click "Joseph Pagan" wrote in message ... i post here my code : http://www.mrexcel.com/forum/showthread.php?t=393635 I too long to post here but there you can download or only see the code. Thanks. "Patrick Molloy" wrote: I'm not sure what the issue is. we really need to see your code using the FIND method in a userform does not have any direct affect on an automatic filter. (Excel 2003) "Joseph Pagan" wrote in message ... My problem is with the autofilter What is my problem? when i use the find button in a userform created in VBA, the autofilter is disable automatically in the worksheet without my intervention the close button disable too the autofilter in the worksheet. What is my question? How i can Troubleshooting my application to never disable the autofilter when the users use the userform especially the find button and the close button |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
The autofilter is disable using the userform
I delete the line but give a error when i use the find button.
"Patrick Molloy" wrote: delete this:- If Sheet1.AutoFilterMode Then Sheet1.Range("A7").AutoFilter which is the last code line in sub Button8_click "Joseph Pagan" wrote in message ... i post here my code : http://www.mrexcel.com/forum/showthread.php?t=393635 I too long to post here but there you can download or only see the code. Thanks. "Patrick Molloy" wrote: I'm not sure what the issue is. we really need to see your code using the FIND method in a userform does not have any direct affect on an automatic filter. (Excel 2003) "Joseph Pagan" wrote in message ... My problem is with the autofilter What is my problem? when i use the find button in a userform created in VBA, the autofilter is disable automatically in the worksheet without my intervention the close button disable too the autofilter in the worksheet. What is my question? How i can Troubleshooting my application to never disable the autofilter when the users use the userform especially the find button and the close button |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The autofilter is disable using the userform | Excel Programming | |||
Disable a userform after first use? | Excel Programming | |||
Disable a userform after first use? | Excel Programming | |||
Disable Userform Events | Excel Programming | |||
UserForm - Disable the 'x' button | Excel Programming |