lynnnow
04-16-2006, 11:39 PM
Hi,
As you will see the image, I've created a userform to mark errors for a particular document. The first frame textboxes get its values from activerow columns, the second and third frame textboxes have entries that are inserted by the user. Only the yellow label in the third frame (Non-Fatal Errors) gets its value from the activerow column.
The multiple values that are inserted in the second and third frame textboxes are separated by semicolons. I would like to count the number of semicolons in the respective "Correct" textbox and display the count in the corresponding textbox next to the "Correct" textbox. I know that a textbox_change event will be used, but I don't know what command should be used to count the number of semicolons. I referred this site for counting semicolons while using it in Excel formulas, but I've not been successful in finding a code for it.
I'm using Excel 1997 on Win 2k. Can't change the combination, so please help me out.
Hoping for a favorable reply.
Lynx : pray2: :help
As you will see the image, I've created a userform to mark errors for a particular document. The first frame textboxes get its values from activerow columns, the second and third frame textboxes have entries that are inserted by the user. Only the yellow label in the third frame (Non-Fatal Errors) gets its value from the activerow column.
The multiple values that are inserted in the second and third frame textboxes are separated by semicolons. I would like to count the number of semicolons in the respective "Correct" textbox and display the count in the corresponding textbox next to the "Correct" textbox. I know that a textbox_change event will be used, but I don't know what command should be used to count the number of semicolons. I referred this site for counting semicolons while using it in Excel formulas, but I've not been successful in finding a code for it.
I'm using Excel 1997 on Win 2k. Can't change the combination, so please help me out.
Hoping for a favorable reply.
Lynx : pray2: :help