I was able to get it all working. Just a silly mistake of missing some code.
Hong Kong 730PM.xlsm
Thank you for any help!
**Tons of thanks to John for the support he has provided to this point.**
I was able to get it all working. Just a silly mistake of missing some code.
Hong Kong 730PM.xlsm
Thank you for any help!
**Tons of thanks to John for the support he has provided to this point.**
Last edited by Chardo; 02-17-2014 at 11:58 PM. Reason: Changes have been made. Almost a complete spreadsheet.
Does anyone have any suggestions?
Hi Chardo
Looking at it...
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
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.
Hi Chardo
Sure, this can be dealt withThis 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.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'll work on this in the AM...not major changes...Code will be much simpler if this is what you wish.Is there anyway to not show/have the combo box on the employee search form?
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks