Load Settings from Txt File

[Lonely]

Hi All,
I have been working with a Excel Macro. Here i have a form which has the following controls:
CheckBox1
CheckBox2
CheckBox3
CheckBox4
Option1
Option2

My macro form has a CommandButton which when pressed loads the settings from a text file to the controls.

However, I want the settings to load to the form atomatically as soon as the form is loaded without the need of pressing the button.

Please can someone help me in this. I am attaching the sample text file and the Excel macro herewith.
Thanks in advance,
Lonely

[biswajitdas]

hi


your problem similar to macro that would be the refresh file


plese use active.refresh = true


Biswajit das