Apply an excel formula but in a VBA instead

[brendalpzm]

I have this issue, I'm creating a form that must have a specific folio according to previous entries.

I'm creating the form with ActiveX fields, I tried to link a textbox value from a cell where I have a simple excel formula that gives me the folio depending on the prveiously entered data.

This is the formula:

="K"&(COUNTIFS(Incidents_Accu!B:B,">="&DATE(YEAR('Input incidents'!F3),1,1),Incidents_Accu!B:B,"<="&DATE(YEAR('Input incidents'!F3),1,1)))+1&"-"&IFERROR(VLOOKUP(H8,'DB_DO NOT MODIFY'!$A$2:$B$5,2,FALSE),"")&(COUNTIFS(Incidents_Accu!B:B,">="&DATE(YEAR('Input incidents'!F3),1,1),Incidents_Accu!B:B,"<="&DATE(YEAR('Input incidents'!F3),1,1),Incidents_Accu!C:C,H8))+1

this folio changes according to other dropdowns

When I linked it to the textbox, it doesn't change fast and sometimes it doesn't change, so I was wondering if there's a way to create that same formula I did to place it in the textbox directly with VBA so I don't have to link it to a cell value.

If you could help me that would be great!