Replace Dialog Box Keeps Moving To Bottom After Replacing Text

  • Thread starter Ronald R. Dodge, Jr.
  • Start date
R

Ronald R. Dodge, Jr.

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. Right now, I'm going through some major revamping of my
production reporting system, which was initially broke in late 2006 by some
changes that were demanded to take place, which then more or less forced me
to move what formulas I more or less had left on the spreadsheet side to VBA
and not only that, but also forced me to more or less switch from using
standard modules to class modules with the only thing the standard modules
doing is directing. Of course part of that also has required me to use
range names to get around the fact that range references within VBA doesn't
adjust like range references within formulas do, so that's why I have been
forced to use range names, which is also how I learned of the hard code
limit of 65,536 being the maximum number of defined names allowed within a
single workbook, though it's not documented in the spec help file. Even
after half of that limit, the file becomes unstable. As for the limit of
defined names, don't be fooled by it allowing you to continue to work in the
workbook after you exceeded the 65,536 defined names, cause once you have
saved the workbook after exceeding that limit, then close it out, once you
go to open it, it will go into repair mode, which then basically makes the
workbook worthless if you have anything much more than just data, formulas
and VBA code. Pretty much anything else that was done in the workbook,
formats, charts, defined names, all of that stuff is either wiped out or set
to the default settings.

Sincerely,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
 
T

Tim Zych

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.
 
R

Ronald R. Dodge, Jr.

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top