InputBox

[JimmiOO]

Hi could someone please help me with this. I have attached a sample sheet to show you what i need.

If you open the sheet you can see there is some data along the top in H1 & K1

I have an order number and a date. What i would like is an Input box that would come up when any of the cells are clicked, that i could type in the Order Number and the Date.

Can this be done so it puts in the data like i have in the sample?

[rwgrietveld]

I'll make smething, but it will take some time.

One Tip: If you would like multiple lines in a cell press Alt-Enter

[JimmiOO]

Thanks alot rwgrietveld, i will look forward to it.

[rwgrietveld]

Here's my solution.

See if you like it. Just press the cells H1:AE1

I have a Userform With Two textboxs (Number and date)
Press OK and a new string is build
Press Cancel and the "Old" text remains

[JimmiOO]

That works great, would it be possible to format it so it keeps the same fonts and sizes as the sample box?

[rwgrietveld]

Here is the new code (replace the old with this)

Please Login or Register  to view this content.

[JimmiOO]

Thats just about it, just one little thing. When i type in the numbers and date (ie) 123456 i get the 123456 and also another character that looks like a little square on the end. Is there anyway to get rid of this?

[rwgrietveld]

This is probably the CHAR(10) which is equal to Alt-Enter.
This makes a newline. This should not show in your cell if it is formatted as "wrap text".

[JimmiOO]

This is probably the CHAR(10) which is equal to Alt-Enter.
This makes a newline. This should not show in your cell if it is formatted as "wrap text".

The cells are formated with "wrap text" but this is still showing, is there another way to get rid of it? or maybe an alternative?

[rwgrietveld]

and if you put this in the cell: ="test"&CHAR(10)&"test"

[JimmiOO]

When i put that into the cell i get test at the top left and test in the bottom left

[JimmiOO]

Does anyone know how to hide this little square? if i take the Chr(10) out it gets rid of it but then i don't get the new line.

[rwgrietveld]

This line of code makes the string

Please Login or Register  to view this content.

/
In my example I don't get the little square and it is funnny that when you use the char(10) (in the test) directly, you don't get it

Beats me ??!!

[JimmiOO]

Yeah it's a strange one it works perfect apart from this square, could there be a setting within excel to tuen these off?

[rwgrietveld]

I can't find any. Please post a new thread with this problem as then other people will be notified.

Sorry I can't help you on this one.

[JimmiOO]

No problem i will mark this as solved, thanks again for your help, hopefully i can find a way to hide this square.