DataForm

[josros60]

hi,

i have this code

ActiveSheet.ShowDataForm

I have a hidden sheet name customers and i have a button in another sheet to open showdataform, what I want is that when i click the button would you like to open the form with customers information of the hidden customers sheet.

Thank you,

 

[josros60]

HI,

anybody please help me

how to display showdataform on hidden sheet with vba?

thanks

 

[Zelcombe]

Hello,

if i am understanding you correctly: you would need to add the sheet and corresponding cell with the customer's information to the corresponding TextBox on the UserForm when the command button is clicked.