Copying text from form into cell.

[Noma9000]

Hello Everyone,

I am a noobie in VBA and I am currently trying to copy the text from a form created in excel (not ActiveX) into a message box but all I get is the choice number.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. I also fixed a VBA syntax error on the last line. --6StringJazzer

is there anywhere to quote the text in the list form?

[6StringJazzer]

Ahlan wa sahlan Noma9000!

What kind of element is entry_type? Can you attach your file for better analysis? See yellow banner at the top of the page.

[Noma9000]

Hello,
entry_type contains a list with categories (string)

[Arkadi]

So you want the text correct? Try:

Please Login or Register  to view this content.

[Noma9000]

oh this worked pretty well!!
Can't thank you enough!

[Noma9000]

I'm sorry but I have another question that's somehow related to this one.

What I wanted to do originally was to create a label or an if/case for when the input is +ve and the list box choice selected is "Income" the entry will be added to income and if the list is -ve and the choice in the list "expense" then cut the entry into the monthly expenses sheet

[Arkadi]

I wonder... what is supposed to happen if the user enters a -ve value and marks it as Income in the dropdown? or +ve and "Expense"? I realize that would be incorrect, but it is my experience people do make mistakes.

[Noma9000]

I wonder... what is supposed to happen if the user enters a -ve value and marks it as Income in the dropdown? or +ve and "Expense"? I realize that would be incorrect, but it is my experience people do make mistakes.

It's just a validation step for users if they do not match a -ve value and the correct type confirmation message will show.

[Arkadi]

Something like this?

Please Login or Register  to view this content.