Change cell format after cell is edited via DataForm

**sintek** · 12-20-2016, 09:51 AM

Hi All

The following code changes the cell colour fill if a sheet is edited directly.

Please Login or Register  to view this content.

How can this be achieved if the sheet is edited via the excel dataform.

Please Login or Register  to view this content.

**sintek** · 12-20-2016, 01:28 PM

AnyOne ??????

**Winon** · 12-20-2016, 07:36 PM

Hello sintek,

Does this Thread in anyway relate to this other Thread ?: http://www.excelforum.com/showthread...21#post4546121

My apologies if it does not!

Is your DataForm a UserForm? or are you referring to a Data Table on another Sheet?

Sorry but I, and probably other Forum Members find your Post a bit vague. Please could you attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you.

**sintek** · 12-21-2016, 01:29 AM

Hi Winon

Wow, I'm feeling special today. Assistance with two posts! No, not related. I have attached a sample workbook.
When I make changes to the cell via worksheet, then the cell is highlighted. However when i make changes via the DataForm, nothing happens.
Can this be rectified somehow or will I have to go and design a UserForm.