+ Reply to Thread
Results 1 to 7 of 7

Visual Basic Editor Find/Replace disabled

  1. 11-29-2015, 06:43 PM #1
    solnajeff
    solnajeff is offline
    Forum Contributor
    Join Date
    04-21-2007
    Location
    Lima, Peru
    MS-Off Ver
    2000, 2007, 2010
    Posts
    674

    Visual Basic Editor Find/Replace disabled

    Hi

    I would be grateful if anyone could advise me regarding a problem I have with the Visual Basic Editor. The find function (Ctrl-f) is inoperative, that is, it is possible to select from a menu, use ctrl-f or click the binoculars, but no dialogue box appears, the same applies to replace (ctrl-h) as well. The problem appears to be common to all office programs and is affecting both office 2007 and 2010.

    Currently I have a clean install of windows 7 with the pre-installed version of office 2007, however I have also tried installing a copy of office 2007 ultimate with no difference, office 2010 is also a clean install.

    I have also tried installing windows 10 and have the same problem.

    I have tried googling and searching within the forum but nothing similar shows up.

    If anyone has come across anything similar, I would appreciate hearing your comments.

    regards

    Jeff
    Reply With QuoteRegister To Reply
  2. 11-29-2015, 08:45 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Visual Basic Editor Find/Replace disabled

    Hi,

    Is it just the shortcut Ctrl-f key combination or does it happen too when you use the menu?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 11-29-2015, 08:46 PM #3
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Visual Basic Editor Find/Replace disabled

    Hello Jeff,

    This sounds a like Registry issue. I would defragment the registry first. That will probably clear up the issue. If that fails then I would suspect your computer may have been infected by a virus, adware, or malware. In which case, you should scan your boot sector and all files for possible infection.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  4. 11-30-2015, 10:24 AM #4
    solnajeff
    solnajeff is offline
    Forum Contributor
    Join Date
    04-21-2007
    Location
    Lima, Peru
    MS-Off Ver
    2000, 2007, 2010
    Posts
    674

    Re: Visual Basic Editor Find/Replace disabled

    Hi

    Thanks for the replies

    It is not possible to access the find function via menu, or shortcut, or clicking the icon.

    Unfortunately defragmenting the registry has not made any difference.

    The problem exists with a clean windows install from the system restore disk and the default installation of office from that disk, plus a clean install of office 10. I had tried upgrading to windows 10 but to no avail. I will try a clean install of windows 10 to see if there is any improvement in which case the problem is with the restore disk.

    Thanks for your time

    Regards

    Jeff
    Reply With QuoteRegister To Reply
  5. 11-30-2015, 10:35 AM #5
    solnajeff
    solnajeff is offline
    Forum Contributor
    Join Date
    04-21-2007
    Location
    Lima, Peru
    MS-Off Ver
    2000, 2007, 2010
    Posts
    674

    Re: Visual Basic Editor Find/Replace disabled

    Hi

    Just to check further I installed office 2000 and no find function exists in that version as well.

    regards

    Jeff
    Reply With QuoteRegister To Reply
  6. 11-30-2015, 09:44 PM #6
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Visual Basic Editor Find/Replace disabled

    Hello Jeff,

    Are you running a 32 bit or 64 bit version of Office? I ask because Windows 7 is a 64 bit OS but can also run 32 bit applications.

    If you are running 64 bit applications, some of the old 32 bit features may not be supported or are absent.

    The Find and Replace function uses the ComDlg32.dll. Since this a 32 bit Dynamic Link Library module, it could be missing on your machine. Use the system find to locate the module on your machine and let me know what you discover.
    Reply With QuoteRegister To Reply
  7. 12-01-2015, 12:02 PM #7
    solnajeff
    solnajeff is offline
    Forum Contributor
    Join Date
    04-21-2007
    Location
    Lima, Peru
    MS-Off Ver
    2000, 2007, 2010
    Posts
    674

    Re: Visual Basic Editor Find/Replace disabled

    Hi Leith

    Thanks for your comments,

    I have now performed a clean install of windows 10 and the Office VBE is functioning as it should. I assume therefore that the problem lies with the recovery disc I was using, as it is the first time I have used it, previously any restore used the restore partition on the hard disk but after upgrading the HDD I needed to use the recovery disk.

    As I need to use some programs that do not work under windows 10 I will try reinstalling Windows 7 and see if I can get it to work from a clean install.

    Many thanks for your time and your comments

    Regards

    Jeff
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to create a new row in the Visual Basic Editor Find and Replace
    By Grf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2013, 02:17 PM
  2. [SOLVED] How to run module in visual basic editor
    By jewellove in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2012, 12:16 AM
  3. Line Nos. in Visual Basic Editor
    By apka in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-12-2012, 05:43 PM
  4. Protect Visual Basic Editor with vba = No Go
    By PY_ in forum Excel General
    Replies: 2
    Last Post: 02-15-2011, 08:55 AM
  5. Find and Replace within workbook - from Visual basic
    By MarkS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2006, 01:30 PM
  6. [SOLVED] Can I run Visual Basic procedure using Excel Visual Basic editor?
    By john.jacobs71 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-26-2005, 10:25 AM
  7. Using Find/Replace in Visual basic to adapt the code
    By Zakynthos in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-08-2005, 11:05 AM
  8. Visual Basic Editor for Excel
    By JoeABC in forum Excel General
    Replies: 1
    Last Post: 08-11-2005, 11:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1