VBA excel not working after textbox is empty

[Jovillanueva]

Hi,

I have a userform with textboxes, combox box and listview.
Once transaferring the data from textboxes to listview control it
terminates or not working the excel when the textbox value is empty.
if the textboxes has an input theres no problem encountered. Any idea guys why it happens. thanks.



here is my vba excel code:
in loading data from textbox to listview.

initialize listview with empty records on column heading display

Please Login or Register  to view this content.

[Jovillanueva]

Here is the error/bugs screen shot.

based on the sample screen shot. i have an empty records in requestor textbox. after ticking the posting command button to transfer the data from listview to textboxes the excel is terminated. any idea guys.

There are spaces in some items and a couple have null values in the subitems. When these particular list items are clicked it crashes the software. Is there a way I can check if a subitem is null or empty? Thanks.



sample1.jpg