Userform.Activate

N

Neil

Hi all, Firstly thanks to everyone who has answered my
questions of the last few days !!!

I have a userform that has some code in the activate
event, this looks at a value in sheet1.range("A1") and
uses this to scan along a data table and fill in some
textboxes, this all works fine, but when i use the
userfrom1.hide option, then change the value on sheet 1,
then use userfrom1.show again, it appears to be still
using the old value, is this becase Im not really
unloading the form but simply hiding it from view ? if so
whats the correct way to unload the form so that it
clears the data from the form.activate event ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Optionbutton Not working 3
Template with fields and premade texts.. 0
Split form 0
How do I set focus (and select text) on a text box on a modeless userform? 0
path error when pointing/going to userform1 1
Userform loses its capabilities...reset??? 0
getting text out of TextBox into code 0
Calling Button click event from Form initialise event? 2

Top