nagavineela
09-16-2010, 05:44 AM
Hi,
I have 18 items in combobox out of which "Others" and "Conn" can be duplicated 'n' of times in the excel.
for e.g., One form has been created for inputs where i have a combobox and 2 textboxes.
I can choose "A" and provide details. Once i click ok, "A" will be removed from the combobox
Choose "B" enter details, "B' will be removed
but "Others" and "Conn" remain in the combobox and can be entered any num of times.
To avoid confusion of which row of "others" module need to be updated, I would like to append with text or string whatever.
the code i used in the input form is as follows:
conncount = conncount + 1
.Offset(Rowcount1, 0).Value = Me.cboModuleName.Text
How do i use concatenate for the above line of code. Please help me in overcoming the issue. If any new ideas please share.
Thanks,
Vineela
I have 18 items in combobox out of which "Others" and "Conn" can be duplicated 'n' of times in the excel.
for e.g., One form has been created for inputs where i have a combobox and 2 textboxes.
I can choose "A" and provide details. Once i click ok, "A" will be removed from the combobox
Choose "B" enter details, "B' will be removed
but "Others" and "Conn" remain in the combobox and can be entered any num of times.
To avoid confusion of which row of "others" module need to be updated, I would like to append with text or string whatever.
the code i used in the input form is as follows:
conncount = conncount + 1
.Offset(Rowcount1, 0).Value = Me.cboModuleName.Text
How do i use concatenate for the above line of code. Please help me in overcoming the issue. If any new ideas please share.
Thanks,
Vineela