Auto add space and / when I press space bar in excel 2003

**bajramo** · 02-28-2016, 04:59 AM

I want to write a macro in Excel so every time I hit space bar (when I'm in column I ) I want to automatically send "space slash and space again".

eg. Im in cell I150. I type 00123 press space bar on my keyboard and instead just blank space, I want to get space slash space again so I can finish my data.

I want this to happen ONLY when im in cell on column I.

Thanks

**:) Sixthsense :)** · 02-28-2016, 05:07 AM

Copy the below code and do right click on sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Please Login or Register  to view this content.

The above code will convert the spaces as you described after pressing the enter button only. It will not replace the space when you are in editing mode.

**bajramo** · 02-28-2016, 05:47 AM

Thanks, I found one more solution:

Please Login or Register  to view this content.

Auto add space and / when I press space bar in excel 2003

LinkBack

Thread Tools

Rate This Thread

Display

Auto add space and / when I press space bar in excel 2003

Re: Auto add space and / when I press space bar in excel 2003

Re: Auto add space and / when I press space bar in excel 2003

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Shift+Space and Ctrl+Space shortcuts intermittently working

VBA: Put extra space before units (keywords) if space is not there

Need VBA Script to press space bar button

parsing text return space to space

[SOLVED] If Cell Starts with a Space, remove that space

replace double space with single space within a range

Paper Space / Model Space ?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions