myname = inputbox

[Irek1974]

Hi,
at the begining of my macro I have :
myname = InputBox("enter the name of the supplier") ' I input for example Supplier number 1

at the end of it I would like to input part of the name entered at the begining (for example Supplier) in cell A1

Can I use : inputbox ?
could somebody help me?
Irek

 

[Joe4]

Not quite sure what you are asking.
Are you asking how to put part of the Input Box value back in cell A1, something like:

Range("A1")=myname
or
Range("A1")=Left(myname,8)

If you are having trouble explaining it, maybe try providing a simple example of what you would like to happen.

 

[Irek1974]

the problem is that the names of the suppliers will differ by length (number of letters). I need to input to A1 the first word from "myname" to which at the begining I entered for example : Nike - june 2009
In this case I need in A1 only NIKE

another example : I input in myname Samsung - July 2009. I need in A1 only Samsung

Not quite sure what you are asking.
Are you asking how to put part of the Input Box value back in cell A1, something like:

Range("A1")=myname
or
Range("A1")=Left(myname,8)

If you are having trouble explaining it, maybe try providing a simple example of what you would like to happen.

 

[TheNoocH]

if there is always a space and dash after what you are looking for in the cell then try this...

  Range("A1") = Left(myname, InStr(1, myname, " -") - 1)

 

[Joe4]

if there is always a space and dash after what you are looking for in the cell then try this...

That was the key piece of information that was missing. As long as you have some "rule" that defines what you want (i.e. everything up to the first space, or everything up to the dash), then something can be programmed to do that. We just needed to know what your rule was...

 

[Irek1974]

thank you very much.
it helped

That was the key piece of information that was missing. As long as you have some "rule" that defines what you want (i.e. everything up to the first space, or everything up to the dash), then something can be programmed to do that. We just needed to know what your rule was...