VBA Code for Close

Paul2k12 · 1 May 2006 at 17:14

I have a user form made via Excel and need to add a button to close the form.

Does anyone know what code I should be using?

Thanks

Paul

~J~ · 1 May 2006 at 18:06

Well, rather than close the form, you could add a bit of code that hides it (therefore allowing you to show it at a later stage).

The VBA code is pretty straight forward.

[sheetname].visible=xlSheetHidden

Paul2k12 · 1 May 2006 at 18:37

Thank you

Paul

Paul2k12 · 1 May 2006 at 19:38

Ok, That works however i have one more problem

I have text boxes that allow the user to type in numbers and descriptions. I need this data to be copied to seperate cells on my worksheet when the OK button is clicked.

Anyone have any ideas?

Thanks

Paul

Paul2k12 · 3 May 2006 at 17:52

sfx · 3 May 2006 at 22:12

Paul2k12 said:
bump

I am not sure as I have not done this for ages but it might be something like:

Worksheets("Sheet1").Cells(2,3).Value = txtYourTextBox.Text

sfx