Get instant live expert help on I need help with excel form controls

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

This version of Excel doesnt support running or interacting with Form Controls I need help
Solved by S. L. in 28 mins
I've been developing Excel applications and have never found a reliable method for applying number formats to userform controls, either in the form initialization event, or in one of the control's events. Can you suggest a definitive guide where I can finally find the answers? Thanks.
Solved by X. E. in 14 mins
I'm trying to protect a sheet to stop anyone from editing protected cells but i need them to be able to open grouped columns. I managed to use macros and created form controls to enable this function to work. The problem I'm having is that Excel online doesn't allow the use of form controls and the file needs to be edited online as there are 14 users who need to edit the file. Is there anyway of protecting the sheet but allowing grouped columns to be shown easily with out them having to manually select the column and click the unhide button?
Solved by X. S. in 14 mins
Hi there I have some data in excel basically some controls I want to show through a formula that if existing controls/total controls is equal to 50% it should show the process as color code amber orange. if less than 50 % it should red if greater than 75% then green
Solved by T. B. in 19 mins
excel keeps changing my cell format. I am trying to link a cell to a tab called "controls" and instead of giving me the answer, the cell keeps showing "=CONTROLS!B6" I changed the format back to general, deleted the "=" then readded the "=". That works, but the minute a press F2 on that cell to recalculate, it goes back to "=CONTROLS!B6"
Solved by B. B. in 13 mins