How can I populate the 8th character of a TextBox??

[bralew]

Hi all,

How can I add the contents of of Combobox7 (which contains the letter "T") to the 8th position/character
of TextBox 5??

[LeoTaxi]

change the red part to combobox7 or any other source

Please Login or Register  to view this content.

Kind regards
Leo

[bralew]

So it would look like this-

Please Login or Register  to view this content.

[bralew]

Thanks, where would I paste this? under-

Private Sub ComboBox7_Change()

[grimes0332]

A more direct way is to use a much under utilised feature of the MID() function. Instead of 'cutting' from a starting position as it is usually used, you can 'stuff' into the string as well...

Please Login or Register  to view this content.

[bralew]

Hi, I get this?

[grimes0332]

My apologies, I misread. That feature can only be used to replace a fixed number of characters with the same number of characters. So you cannot replace from position 8 with a length of 1 and then specify more than 1 character as the replacement. If you say from position 8 with a length of 8, then the original string must be longer than 16 characters total or your replacement gets truncated. This will not change the length of the original string.

[bralew]

Hi,

I was kindly given this code by Leo Taxi but cannot get it to run. Any ideas?

Please Login or Register  to view this content.

[LeoTaxi]

maybe change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Else
Excel File


Cheers
Leo

[jolivanes]

Or

Please Login or Register  to view this content.

[bralew]

thanks chaps, I'm in the office now, I'll give it a whirl and get back to you. Cheers

[bralew]

Thank You, it worked brilliantly!!!