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

[mohsinbipu]

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?

 

[GWteB]

Your problem occurs due to the fact the RefEdit control isn't reliable. You might take a look over here for an alternative ...

Alternative to Excel's Flaky RefEdit Control - Peltier Tech

I recently wrote about Using RefEdit Controls in Excel Dialogs. I use(d) them a lot, and they are a handy way on a dialog to get a range that the user wants a procedure to use. These controls are prone to incompatibility issues between versions of Excel, particularly between Classic Excel (up to...

peltiertech.com