messy huh?

[everscern]

pls look at the above picture. now.. my dialog boxes take me to the worksheet 'INVENTORY' but when ever I want to enter something at the INVENTORY worksheet, I've to close all the annoying dialog boxes. Is it possible to automatically close them once they link me to the INVENTORY worksheet?

 

[agihcam]

add line of codes on the Inventory button. something like;

unload Userform1
unload Userform2. etc

 

[everscern]

erm.. but i didn't use userforms to creat my dialog boxes. I used Excel

 

[agihcam]

ah.. ok. i thought you have used userform for those dialog boxes.
just ignore my post. maybe someone can help.

 

[jindon]

Can't you just hide the forms?

 

[everscern]

how? I'm sorry i dun understand.

 

[jindon]

Did you make this workbook or someone else?

 

[everscern]

me. but i'm a beginner

 

[wavemehello]

wow! how did you make those dialog boxes with all those command buttons without using forms? Is it possible? how?

 

[jindon]

You must have created those forms for yourself.