Ufdjrw

Closest Prime Number

What Brexit proposals are on the table in the indicative votes on the 27th of March 2019?

Term for the "extreme-extension" version of a straw man fallacy?

Is exact Kanji stroke length important?

What happens if you roll doubles 3 times then land on "Go to jail?"

Crossing the line between justified force and brutality

Would this custom Sorcerer variant that can only learn any verbal-component-only spell be unbalanced?

What does the word "Atten" mean?

Large drywall patch supports

How can a function with a hole (removable discontinuity) equal a function with no hole?

Sort a list by elements of another list

Why not increase contact surface when reentering the atmosphere?

Class Action - which options I have?

Do the temporary hit points from the Battlerager barbarian's Reckless Abandon stack if I make multiple attacks on my turn?

Unreliable Magic - Is it worth it?

How to write papers efficiently when English isn't my first language?

How does the UK government determine the size of a mandate?

Was Spock the First Vulcan in Starfleet?

Do sorcerers' Subtle Spells require a skill check to be unseen?

Detecting if an element is found inside a container

Why, precisely, is argon used in neutrino experiments?

Is `x >> pure y` equivalent to `liftM (const y) x`

Are student evaluations of teaching assistants read by others in the faculty?

How long to clear the 'suck zone' of a turbofan after start is initiated?

Excel VBA Userform Modeless loses focus

How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?Clicking “X” on an Excel userform sometimes closes spreadsheetHow to avoid using Select in Excel VBAWhy, after launching a userform from a userform, does unloading the 2nd userform close both?Userform showing when not wanted, not called forWhy VBA global variables loses values when closing UserForm?Excel VBA - return focus to worksheet after UserForm Button clickExcel modeless userform focus issueBring Focus to Modeless Userform without Clicking (Excel 2010 VBA)Set focus back to Excel after loading modeless userform

0

I have a form called frmMain that I call from a module using:

frmMain.show

I need to be able to use other spreadsheets whilst this is open, so I changed the way the userform is opened with:

frmMain.show vbModeless

the form opens and I can also use other spreadsheets.

The problem I have is that when frmMain opens, I can't click anything inside it, I have to click a cell in the worksheet behind it and then click back into it. It seems to lose its focus to the worksheet when it's opened.

I've tried change the property Show Modal to false and this produces the same result.

I've also tried DoEvents and also Repaint after the .show code, but I can't get it to work.

Any ideas?

excel vba userform

share|improve this question

edited Mar 7 at 13:00

Pᴇʜ

24.7k63052

asked Mar 7 at 12:04

Walshie1987Walshie1987

901212

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I wasn't able to replicate your problem. Please share the userform code and also check if there are any events behind the worksheet you're working with that may affect the userform behaviour.
  
  – Ricardo Diaz
  Mar 8 at 2:22
  

  
  
  
  

add a comment | 

0

I have a form called frmMain that I call from a module using:

frmMain.show

I need to be able to use other spreadsheets whilst this is open, so I changed the way the userform is opened with:

frmMain.show vbModeless

the form opens and I can also use other spreadsheets.

The problem I have is that when frmMain opens, I can't click anything inside it, I have to click a cell in the worksheet behind it and then click back into it. It seems to lose its focus to the worksheet when it's opened.

I've tried change the property Show Modal to false and this produces the same result.

I've also tried DoEvents and also Repaint after the .show code, but I can't get it to work.

Any ideas?

excel vba userform

share|improve this question

edited Mar 7 at 13:00

Pᴇʜ

24.7k63052

asked Mar 7 at 12:04

Walshie1987Walshie1987

901212

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I wasn't able to replicate your problem. Please share the userform code and also check if there are any events behind the worksheet you're working with that may affect the userform behaviour.
  
  – Ricardo Diaz
  Mar 8 at 2:22
  

  
  
  
  

add a comment | 

I have a form called frmMain that I call from a module using:

frmMain.show

I need to be able to use other spreadsheets whilst this is open, so I changed the way the userform is opened with:

frmMain.show vbModeless

the form opens and I can also use other spreadsheets.

The problem I have is that when frmMain opens, I can't click anything inside it, I have to click a cell in the worksheet behind it and then click back into it. It seems to lose its focus to the worksheet when it's opened.

I've tried change the property Show Modal to false and this produces the same result.

I've also tried DoEvents and also Repaint after the .show code, but I can't get it to work.

Any ideas?

excel vba userform

share|improve this question

edited Mar 7 at 13:00

Pᴇʜ

24.7k63052

asked Mar 7 at 12:04

Walshie1987Walshie1987

901212

frmMain.show

frmMain.show vbModeless

share|improve this question

edited Mar 7 at 13:00

Pᴇʜ

24.7k63052

asked Mar 7 at 12:04

Walshie1987Walshie1987

901212

share|improve this question

edited Mar 7 at 13:00

Pᴇʜ

24.7k63052

asked Mar 7 at 12:04

Walshie1987Walshie1987

901212

edited Mar 7 at 13:00

Pᴇʜ

24.7k63052

edited Mar 7 at 13:00

Pᴇʜ

24.7k63052

asked Mar 7 at 12:04

Walshie1987Walshie1987

901212

asked Mar 7 at 12:04

Walshie1987Walshie1987

901212