• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro control cell contain

A

Abhijeet

Active Member
Hi

I have Data in Excel in Column A i want control what ever format & Names given that Name & Format should be enter in that cell other wise that cell can protect.Any thing not enter in that cell
is their any macro for this.Please tell me

Names are in Column AB1:AB25
 
Abhijeet

I find your post confusing. By now you must know that posting a file will give you the best chance of a satisfactory outcome. Please do that with the output in a seperate area.

Smallman
 
Hi
In this file what i expected result i post Name range Data in AB column.What ever data in column AB that show in A column apart from any data should not enter in column A cells that should protect by macro
 

Attachments

  • Cell Control.xlsx
    10.5 KB · Views: 5
I could be a bit thick but I see no relationship between the data in Col AB and the data in Column A. You will need to clearly articulate what you are trying to do. I could guess but based on the data it would be a wild guess.

Late here on the East Coast of Oz - sandman beckons!!

Take care

Smallman
 
Hi, Abhijeet!

I downloaded your workbook and there's nothing there that I could associate to your original issue description. I assume that English isn't your native language (as neither is mine), I don't know which one is it, but could you give a try and use Google Translator placing the description of the problem in your language and then get it translated into English? Maybe that helps people understand what you post.

Regards!
 
You must log in or register to reply here.
Back
Top