Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

Userform not repainting itself or whatever

excel useform vba

I have a useform...that I'm using to search for data in access..
When the userform loads, I can move the form around with no problem...

AfterI hit a search button and fill the form with data in the listboxes...anytime I try to move the form around..it makes the mess below ??

Thanks
fordraiders


userform-weird.png
0
Fordraiders
Asked:
Fordraiders
  • 4
  • 3
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
This is a common problem when other parts of the system have control and Excel is not given any cycles to redraw.

In this state, is your form code idle or are you waiting for a called process to finish?

Kevin
0
 
FordraidersAuthor Commented:
yes, its idle
0
 
zorvek (Kevin Jones)ConsultantCommented:
Are you invoking the form by clicking on an ActiveX control on the worksheet?

Kevin
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
FordraidersAuthor Commented:

Are you invoking the form by clicking on an ActiveX control on the worksheet?


no
0
 
zorvek (Kevin Jones)ConsultantCommented:
Have you tried showing the form modeless?

Kevin
0
 
FordraidersAuthor Commented:
Have you tried showing the form modeless?

Worked  ...Thanks !
0
 
FordraidersAuthor Commented:
Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now