Userform question

[Katsdog]

I have a user form with a few text boxes.

Can someone please give an example of what's the best way for the user forms text boxes hold user inputted values in them and for those values to be referenced by other macros.

I know that once a user form is unloaded, all of the data in it goes away. So I would need a command button in it to simply hide the user form.
Is there a way to prevent a user form from being closed by pressing the x at the top right?

I have many rows for which I intend to create such a user form. And the values from the text boxes will be used as values in other code.

Does anyone know of ways to go about this?

Than you

[mehmetcik]

hi

you should store all your userform information onto a worksheet as you make changes.

That way you will only lose information if you close the workbook without saving it.

Then again your code could force the userform to be saved. So even then you would be safe.

You could sun a subroutine each time anything is changed on the userform to save the data.

I will dig out a some sample code for you. BRB

[mehmetcik]

Darn the system crashed on me after I wrote a lot of code for you.

I will try again.

[mehmetcik]

Ok I will create this in stages for you.

When you activate the userform, declare a public array to store your textbox data.

Also Dimension the array.

Please Login or Register  to view this content.

[mehmetcik]

Please Login or Register  to view this content.

using "Saver(6) passes the textbox number to the saver routine, so you only need to save the textbox that has been changed.

using "saver2" doesn't pass the text box no to Saver2 and means you have to save all textboxes whenever one is changed.

Please Login or Register  to view this content.

[mehmetcik]

Ok

That should give you the germ of an idea.

Good Luck.

[Katsdog]

Thank you, I will play with the code

[Katsdog]

So suppose I have a user form with a few numbers in it. And I want to use the value from userform3.textbox5 as a value in another piece of code.
What would the correct syntax be?

[mehmetcik]

The array will store numbers as well as text

you could use

Please Login or Register  to view this content.

to check that the contents of a specific textbox is numerical, if not do something like clear it or delete all the text in that box.

The subroutine below is something I wrote to ensure that the contents of a text box are numerical. The N is the textbox number.

Please Login or Register  to view this content.

[mehmetcik]

The Numeric function was created to accept either a number or a series of numbers separated by "," or "/".

[Katsdog]

Thanks man!