Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Refresh a userform should active cell alter!

Status
Not open for further replies.
APElliott

APElliott

Technical User
Jul 9, 2002
165
GB
Hello,

I have a userform with values shown on it, but they do not update unless closed down and re run. Is there a code to close & re run the form should a value change?

Thankyou,

Andrew
 
Sort by date Sort by votes
One thing you can do is the DoEvents code right after you change the form. If you need more info, let me know (mjbigelow@hotmail.com)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
588
huiettcm
huiettcm
AncientTiger
  • Locked
  • Question
How to screenshot a userform and save the capture as JPG 1
Replies
7
Views
1K
AncientTiger
AncientTiger
thanhthanh12
  • Locked
  • Question
How create a button to record a macro in userform
Replies
5
Views
236
thanhthanh12
thanhthanh12
JTBorton
  • Locked
  • Question
Determine when a userform is closes without the Terminate event 1
Replies
6
Views
689
JTBorton
JTBorton
sal21
  • Locked
  • Question
scrping in listbox in a web page
Replies
0
Views
455
sal21
sal21

Part and Inventory Search

Sponsor

Back
Top