Updating userform based upon input cell - Issues moving reworked code

Does anyone have any suggestions?

Originally Posted by jaslake

Hi Chardo

Looking at it...

Thank you. I'm brand new to VBA and have been burning my brain out all weekend long trying to figure out how to do different things for this file.

Originally Posted by jaslake

Hi Chardo

Try the Code in the attached...let me know of issues...

This works great! Now that I'm looking at the code though I have a few questions in regards to making this a little more realistic.

1.) Is there a way to make it so credit card info doesn't show up but it ONLY updates the cells if someone types in it?
--I tried deleting the references to pull the data up which worked but then if you hit the update button it will paste the blank info into the database.

2.) Is there anyway to not show/have the combo box on the employee search form? I'm guessing not since you added it.

Again, thank you soo much for the help. I was so lost.

Originally Posted by jaslake

Hi Chardo

Sure, this can be dealt with
This can also be dealt with if you wish the User to type in the entire Employee ID as in your original User Form. There will be no Type Ahead feature and, consequently, no Drop Down List to choose from.

I'll work on this in the AM...not major changes...Code will be much simpler if this is what you wish.

That would be great - thank you! I was just going to have it give them a msgbox if they enter an invalid employee id. This is obviously a fake database and such the user knows that it only lies between 10000-10500.

I see your also an Ohioan

Originally Posted by jaslake

Hi Chardo

Try the Code in the attached...

Thank you so much! I made some changes to make it a little more "realistic" to what a business might allow. Specifically, only executives are allowed to change their business class for flights. I believe I put some code in that will work although it might be crude. The only thing left I was wondering about is if I can make the "CCexpirationdate" be pasted into the database as MM/YY. I have attempted to do this following how you formatted the CCnumber line but it doesn't seem to be taking.

Do you have any suggestions?

Update Database v3.xlsm

I'm also trying to import this code into my actual final spreadsheet and it's getting hung up on the:

Private Sub CommandButton1_Click()
Call Find_Me
End Sub

--I've been trying to locate the Find_Me coding but I'm being highly unsuccessful. In the process of googling this right now to try and find a solution on my own.

Originally Posted by jaslake

Hi Chardo

Try the Code in the attached...

Hong Kong Final - WIP-1.xlsm

That is my full workbook and I am swimming in issues now. I'm confused as to why certain things that worked before are now failing.

Originally Posted by jaslake

Hi Chardo

Add these lines of Code to the Workbook Open Event

Please Login or Register  to view this content.

Compile error.PNGWorkbook open.PNG

This is what I'm still currently getting.

Hong Kong - BE1.xlsm

Here is what my file actually is right now.