i need some help in userform

[elbazreturn]

i want a code to make auto-update to the userform screen

so when anythinh changes in the excel sheet it happens immediately in the userform screen

 

[James006]

Hello,

Do not know what you are processing ... but what you are asking for is already the case with : Private Sub UserForm_Initialize()

Hope this will help

 

[elbazreturn]

Hello,

Do not know what you are processing ... but what you are asking for is already the case with : Private Sub UserForm_Initialize()

Hope this will help

no this is not what i need but thank you for your help

like if you have a bill and there's 2 staff in it and you want to delete one of them so you delete it (in the userform not from the sheet) the staff deleted but the name of it in the userform still exist

you got it or not ?

 

[James006]

Have you tried : UserForm_Initialize ... ???<code></code>

 

[elbazreturn]

Have you tried : UserForm_Initialize ... ???<code></code>

yes and every time i need to close the userform and opens it again

 

[My Aswer Is This]

I would think we need more specific details about what you have on your UserForm.

To expect a UserForm to update itself every time you do anything in your Workbook may be a big task.

So if you enter "Yes" in Range("A1") you want all the controls on your userform to update.
And this would also apply to all the 1 billion or so cells in your workbook. That would be a big tasking.

 

[James006]

Have you tried :UserForm1.Repaint ...?<code></code>