Linking Comboboxes to their corresponding cell

[RayMcGirk]

Hello,

I am trying to link a large number of combo boxes to their corresponding cell. The Combo Boxes are in cells K2:K300, and I need a quick way to link them all to their current cell. I know how to do it manually, but manually linking 299 cells would take all day. :/

Any help would be appreciated.

 

[My Aswer Is This]

Why do you need 300 Comboboxes?

This will be a lot of work providing code in all these Boxes.
There should be a easier way to do things

 

[RayMcGirk]

I am looking to indicate which bank account the deposit/payment is going to, such as Operating or Trust, etc. Basically I type in the client name, type of payment, amount of payment, date of payment, and the account that the deposit is going to. At the end of the month I can set up a separate tab to calculate the total deposits/payment per account per day so that I have a figure to match with the accounting software at the end of the month. This spreadsheet also exists to maintain chain of custody so that no payments are lost in transit throughout the office.

I could type it manually, however an misspelling could prevent the figure being tallied properly at the end of the month, causing some issues. If you can think of an easier way I would certainly appreciate it as much as my original question.

Thank you for your quick response.

P.S. I think my original reply was to the user and not the thread. Sorry if this gets double-posted.

 

[My Aswer Is This]

So I think your saying you have three unique values you put in each row.

Account Number in column "A" Name in column "B'" and type account in column "C" etc.
You want to be sure you enter name correctly and maybe account number also etc.

Have you ever used a Data Validation list?

This is a list of values you set up and then when you click on any cell in column "A" for example you will see the list of names and when you select one that name will be entered into the column..

Would something like this work for you.

You could also have a list of account types to choose from in column "C" for example. the value would only be entered when you click on the list.

How do you always know the customers exact name account number etc.

There is a way where if you selected the customers name from the validation list in column "A" a Vba script could enter the other information related to that customer into the proper cell on that row.

For example select George from a validation list and George's account number could a automatically put into column "C" his account type in column "E"

Most of this would require no comboboxes and just a little bit of code we could write for you.

If I were you I would take my time setting this up and try this way on a small scale for now and see what you think.

If you wanted something like this you would need to provide exact details where each value goes.

 

[RayMcGirk]

Wow, I am certainly impressed and grateful for what you are willing to help me with; fortunately what I need help with is much simpler. I looked into Data Validation and it actually does exactly what I need!

Considering we have 5000+ clients not including potential clients, I am okay with inputting client data manually in each cell for now. Also, misspelling of client names or account numbers in this database is acceptable as I do not use this database for anything other than a comparison, and a name or account misspelling would not go unnoticed during the reconciliation. I just needed a fool-proof way to prevent people (including myself) from misspelling the type of account the funds are being put into, as I have a formula to tally up their totals depending upon which account is input.

Thank you so much for your help!

 

[My Aswer Is This]

Glad to see your using data validation will do all you need. Take care and have a nice day.

Wow, I am certainly impressed and grateful for what you are willing to help me with; fortunately what I need help with is much simpler. I looked into Data Validation and it actually does exactly what I need!

Considering we have 5000+ clients not including potential clients, I am okay with inputting client data manually in each cell for now. Also, misspelling of client names or account numbers in this database is acceptable as I do not use this database for anything other than a comparison, and a name or account misspelling would not go unnoticed during the reconciliation. I just needed a fool-proof way to prevent people (including myself) from misspelling the type of account the funds are being put into, as I have a formula to tally up their totals depending upon which account is input.

Thank you so much for your help!