Posted to microsoft.public.excel.programming

Gabe Tiger Gabe Tiger is offline

external usenet poster

Posts: 2

How do I restrict an inputbox to 5<= string characters?

I am still new with VBA...

I need help writing a macro that will restrict an input to 1 to 5
characters of the alphabet. This input should be prompted using the
application.inputbox function.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I restrict a text column to a specific number of characters?	Irene Threadgold	Excel Discussion (Misc queries)	4	November 5th 09 09:31 PM
Insert Leading Characters If String Is Only 7 Characters	Paperback Writer	Excel Discussion (Misc queries)	2	April 21st 09 09:07 PM
preventing input of illegal characters in an inputbox	drofnats	Excel Programming	8	July 11th 04 09:25 PM
InputBox function - prompt string limit	Marcotte A[_2_]	Excel Programming	4	June 9th 04 09:47 AM
Fix InputBox - Returning Empty String	spurtniq[_3_]	Excel Programming	7	December 31st 03 06:23 PM

All times are GMT +1. The time now is 10:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us