Floating selectable colors table

Hello,
Trying to create a selectable colors table which floats around a Spreadsheet – a ange of 15 different colors
Currently, if I want to change a color, I use Format Painter, but is a multiple step process having to go to an existing colored cell, go to the Menu Bar, select Painter, then go to the cell I want to color.
It becomes a time consuming multi-step process.
Hoping there is something available like:
See attached example where have created a range of colors and Saved as picture which I can manually drag about a sheet – not selectable within the picture.
What I would like is to select a color from within a floating table, and directly paste as background color into chosen cell/s. Two clicks – one in the floating table to select, and one into the chosen cell/s.
Multiple windows works but still many steps switching screens etc to achieve my “wish’.
Any suggestions including VBA would be appreciated please.

Fantastic solution. Thankyou 6String
After trying various and thought about this a little more, complete wish list is detailed on attached.
I know some of the items listed can be done separately but I am hoping to achieve a smarter solution involving fewer steps.
Hope you can assist please.
Would need to add VBA to an existing Workbook
I note support VBA codes supplied thankyou.
Is the complete wish list code likely to be available please? (appropriate recognition of course)
As a moderator, you have my permission to send code to my registered email address please.

Thank you again 6String

I am working on this item as part of a project for an amateur sporting organisation - so I am pro-bono as well.

How do I broadcast the inquiry to the wider no-fee community please?

Data Form is new to me - so need to do lots of homework there

Meanwhile, if your proposal of the Multi-Tab version is still available, would appreciate an updated version

Multisheet version was a quick change, attached. There is still just one button to bring up the color form. This could be located just about anywhere you want.

I did look at the file you attached and I didn't see anything that looked like a wish list. It looked like an update to your original file, rather than the solution I provided.

I would suggest starting a new thread, which will get more attention than this one that is already underway. That is the best way to get attention. Also, traffic is slow on weekends and you might the best response waiting until early Monday.

By the way, the solution I provided is a little advanced, even for someone familiar with VBA. I can walk you through it if you're interested in learning about it, but it will take some time.

Thanks again 6String

I sent you the incorrect amended WB with my wish list - correct on e is now attached.

I reviewed your wish list, and you are basically looking to hire an Excel consultant. The general feel of this forum is questions like, "I am solving an Excel problem and am stuck on something. Can you help me figure this thing out?" Your question is more like, "I have requirements for an advanced Excel feature and I would like someone to build it for me." Your wish list is very doable but would be a lot of work. Consider posting to our Commercial Services forum. It has a FAQ to explain how points work and how to post.

When you find someone willing to take on this project you will need to consider the following items from your list:

* Color painting to have no effect on any data / formula / data validation list already in a cell
This is already true of the solution I provided.

* Still able to lock / hide cells and formulae whether colored or not
This is already true of the solution I provided.

* Need to add as VBA to current WorkBook. Maybe activate via Macro?
I don't understand what you mean by this. It is activated by macro. Maybe you mean that you would like this to be an add-in so you can use it in any workbook.

* Need to use Color Picker on up to 22 Tabs (Sheets) at same time
This is already true of the (second) solution I provided. There is no limit to what sheets

Many thanks for your recommendations, suggestions and feedback 6String.
If I proceed down the open forum, do I use the General Tab or VBA for a new posting?
Do you have any objection to my proposing the project become enhancements to the work you have completed please? as you point out most of the basic parts is already included thanks to your efforts. I believe what I now seek is cosmetics to make the display smaller and vertical as per VisionSmart=Floating_2+All Sheets-B as attached
My thinking regarding the Macro option was instead of creating an Add-in function, a Macro button could start the process and then use the end option (already in your version) to end the option. - Not absolutely critical so can work without it.

Your advice please.

I would suggest the VBA forum, because your problem absolutely requires VBA.

I have no objection at all to publishing what I already provided. I provided it free of charge with no claims, and it's already posted here anyway

When you say "macro button" do you mean in the Ribbon? Because my solution includes a button that starts the macro. To put a button in the Ribbon you could put my macro modules (form and other code) into your PERSONAL.XLSB file so it will always be available to any workbook. To give this to other people to use, it would be better to make it an add-in.

I plan to raise a new incident a in the VBA section

Mean while, I plan to trial your solution as is in two days time at a sporting event.
One item you may be able to advise on now please - How can I make the start button start from any tab as well as the original tab
I Have copied and pasted the button elsewhere but is does not activate from these other tabs?
Alternatively, how do I place the start button in the ribbon so it will start no matter what Tab is in use?
Have been reading up on Data forms(great tool) and VBA etc - but lots to learn moving forward

Thankyou Winon. I get that and works fine, Now is there a way I can create a working macro in the Macro Menu which 'points' to the Active-X?
Reason being some of the Tabs in my planned workbook will be protected and hidden. If I can use a Menu Macro to start the color picker, I don't need to open Tabs.