Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I see what you mean, it seems it measures the height of the Immediate/Watch
panes, then it takes that same height and measures up from the top of the task bar edge, then has the top edge of the find/replace dialog box placed at that point, so by having those 2 panes at a small amount height wise (which I normally do have it at a small height in most cases, but every now and then do have it at a larger height point when I'm testing something), the Find/Replace dialog box's bottom is off the screen on this account. I can't even see the command buttons, even if the VBE is in "Restore" window state with ample amount of space between the bottom of that window and the top of the task bar area. This is using XLXP, SP3 (VB6.3) "Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNET wrote in message ... I have noticed this too, and have been bugged by it for some time but never tried to figure out why until now. Seems the Find/Replace dialog is dependent on the location of the Immediate window. When possible, it's positioned level with it. Heightening, removing, or lowering the Immediate window enough seems to make the Find/Replace dialog play nicer. The behavior is made worse by a taller Taskbar too. -- Tim Zych SF, CA "Ronald R. Dodge, Jr." wrote in message ... How do I prevent the Replace dialog box from moving at all within VBA? Every time I have it find and replace text in VBA, it's moving to the very bottom of the screen with the lower part of it not even showing. I really hate this behavior. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Replace fuction replacing all instead of selected cells | Excel Programming | |||
Find/Replace Macro with format changes to the replacing number | Excel Programming | |||
Using Replace command for replacing a character by an ALT+ENTER | Excel Worksheet Functions | |||
How do I replace an asterisk without replacing everything? | Excel Discussion (Misc queries) | |||
Moving Items to bottom of spreadsheet based on criteria | Excel Programming |