Amro El ghazawei
New Member
- Joined
- Feb 27, 2021
- Messages
- 15
- Office Version
- 2016
- Platform
- Windows
Hi,
i create a user from for projects data , with a lot of text boxes & combo boxes, i named each text box & combo box with different names like PO_value , PO_rev .....etc instead of textbox 1,2,3 ....etc.
i assign each textbox/combo box to a column in sheet , using the normal way like
.Cells(iRow, 2) = frmForm.PO_SCOPE.Value
.Cells(iRow, 3) = frmForm.PO_SECTOR.Value
as i said i have more than 200 test box/combo box i wrote the code for the remaining and it work fine , but it takes time for processing it appears like the excel is frozen.
i was thinking to use an array for this assignment but i am not so familiar with array issues
i create a user from for projects data , with a lot of text boxes & combo boxes, i named each text box & combo box with different names like PO_value , PO_rev .....etc instead of textbox 1,2,3 ....etc.
i assign each textbox/combo box to a column in sheet , using the normal way like
.Cells(iRow, 2) = frmForm.PO_SCOPE.Value
.Cells(iRow, 3) = frmForm.PO_SECTOR.Value
as i said i have more than 200 test box/combo box i wrote the code for the remaining and it work fine , but it takes time for processing it appears like the excel is frozen.
i was thinking to use an array for this assignment but i am not so familiar with array issues