Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to format excel cell as a text field

Status
Not open for further replies.

Plato2

Programmer
Joined
Dec 6, 2002
Messages
192
Location
US
How to format a cell as a text field programatically?
thanks in advance
 
Have you tried the macro record button?
 
Plato,

1. Turn on your macro recorder

2. Format/Cells/Category - Text

3. Turn off macro recorder.

4. Observe code.

Give an man a fish and he eats for a day.

TEACH a man to fish, and he eats for a lifetime


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
 
Plato,

You have posted 71 questions. Not ONCE have you demonstrated your gratitude for the expert help that has been given to you.

In fact, you seem to IGNORE good advice previously given, like making use of the macro recorder. This does not reflect well on our programming profession.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top