Thank you so much, Sir. You always keep us updated with the useful new,

@Exceltrainingvideos

2 жыл бұрын

So nice of you. Please share my Excel channel with all your friends.

How can i used change events of Dynamically Generated textbox in case if i want to used

Hi sir how are you i hope you are well sir I need one help I have one big excel data like production tracking report now I convert to all serial numbers I need to separate pdf the steps all I clearly completed sir problem ones I click the button then around 3000 serial number all data successfully converted pdf bt all single single pdf so I need to all the single file convert to compine file please how to write the code sir I hop your understand my problem

@Exceltrainingvideos

2 жыл бұрын

Let me check

@krishnajagadeesh6307

2 жыл бұрын

Thank you sir

Thanks. I have another issue. I have a textbox to accept date. I have these validations in the userform to check if the contents of the textbox contain a valid date. If not I need to warn the user and put the cursor back to the textbox. I have these validations within *BeforeUpdate* event of textbox. Validations do work. But the problem is this event is fired *twice* , though I have added Exit sub. Any inputs.... Code: Private Sub txtDOB_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) With txtDOB If Len(Trim(.Text)) > 0 Then If IsDate(Trim(.Text)) Then .Text = Format(DateValue(.Text), "dd/mmm/yyyy") .BackColor = vbWindowBackground Else MsgBox "The date entered is invalid!" & vbCrLf & "Please enter a valid date", vbCritical + vbOKOnly, "Data Entry - Error" .BackColor = &HC0C0FF Cancel = True Exit Sub End If End If End With End Sub

My work is updating due to your video please link a video worksheet change with multiple cell value

@Exceltrainingvideos

2 жыл бұрын

Just use the keyword 'change' to view worksheet change event macro in Excel on my channel.