If RefEdit control in focus/active, then if trying to open a hyperlink is crashing Excel

mohsinbipu

New Member
Joined
Feb 19, 2021
Messages
7
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. Web
Background:
In my Excel userform, I have
  1. RefEdit control.
  2. 03 Radio buttons
  3. A label (when click, it opens a hyperlink).
  4. Command to run the code.
I can select range from the sheet with RefEdit control and when I press the command button, Userform/Excel is working absolutely fine.

When a problem arises:
If I click RefEdit to select range from the sheet (RefEdit in Focus) and instead of selecting sheet range if I click on the hyperlink button, then the problem arises- Else Excel does not respond, or userform disappears automatically, or Excel freeze.

When a problem does not arise:
If I click RefEdit to select range from the sheet (RefEdit in Focus) and instead of selecting sheet range if I click on the command button or Ration button.

Only problem is coming when RefEdit is in Focus and Hyperlink label are click.

Can anyone please help with this? I know I can solve this with Application.Input method or If I create hyperlink command button instead of hyperlink label. But I want to know why this problem is occurring?
 

Attachments

  • refedit problem .jpg
    refedit problem .jpg
    19.2 KB · Views: 3

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
2,582
Office Version
  1. 2013
Platform
  1. Windows
Your problem occurs due to the fact the RefEdit control isn't reliable. You might take a look over here for an alternative ...

 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,492
Messages
5,764,694
Members
425,231
Latest member
mramb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top