Excel How to use InputBox as part of Formula

[zhead]

I have the macro below where I would like the user to enter the number of characters using an input box. I have pretty much exhausted my excel macro abilities trying to get it to work. Any help would be deeply appreciated. Thanks in advance.

Please Login or Register  to view this content.

[TMS]

Try changing this

Please Login or Register  to view this content.

To this

Please Login or Register  to view this content.

[Greg M]

Hi there,

It seems that you want to remove the rightmost x characters from the text value - if this is the case, try using:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

[zhead]

TMS thanks for your reply. Unfortunately I receive this old friend of mine.
Run-time error '1004':

Application-defined or object-defined error

[zhead]

Greg M that works great thanks so very much

[Greg M]

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M

[TMS]

You're welcome. Thanks for the rep.

Looks like I left in a bracket surplus to requirements

Please Login or Register  to view this content.