Posted to microsoft.public.excel.misc

DaveF[_2_] DaveF[_2_] is offline

external usenet poster

Posts: 2

excel input mask for textbox

can anyone help me on this textbox issue:

Private Sub IBAN1_AfterUpdate()

IBAN1.Text = Format(IBAN1.Value, "#### #### #### #### #### ####
#### #### ##")

End Sub

when the user enters numbers, the textbox is change the input.

example 1255 2222 3333 3666 5555 6666 99999 88888 88

1255 2222 3333 3666 0000 0000 0000 0000 00

any ideas

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
Need A date Mask format for a Textbox on UserForm	[email protected]	Excel Discussion (Misc queries)	2	November 4th 07 02:27 AM
Input Mask	Steven	Excel Worksheet Functions	1	January 16th 06 11:27 PM
input mask in excel	Osama Mira	Excel Worksheet Functions	6	December 6th 05 10:00 PM
input mask in excel sheet	Osama Mira	Excel Worksheet Functions	1	December 4th 05 05:59 PM
Input Mask	Jimmy Clay	New Users to Excel	3	December 1st 04 01:16 AM

All times are GMT +1. The time now is 01:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us