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

This version of Excel doesnt support running or interacting with Form Controls I need help

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.

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?

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

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"