ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Picture box ??? (https://www.excelbanter.com/excel-discussion-misc-queries/35641-picture-box.html)

Anthony

Picture box ???
 
Want to insert various pictures into a set spot on a template. In order to
make it simple and quick would be great if you could set a box to drop
picinto similar to text box.

Got a reply suggesting a Picture box with no other info. I can't find this
as such. Does it exist??

anthony

moi

If you can see a TextBox on your controls toolbar, then I don't see why
there isn't a PictureBox.
Of course there was no other info - a TextBox is for text, that's why it's
called a TEXT-box.
So a PictureBox is for pictures.

'Does it exist??'

What do you think?
That I wrap my pictures in a textbox, and buy my bicycle at the butcher?


"Anthony" schreef in bericht
...
Want to insert various pictures into a set spot on a template. In order
to
make it simple and quick would be great if you could set a box to drop
picinto similar to text box.

Got a reply suggesting a Picture box with no other info. I can't find this
as such. Does it exist??

anthony




Anthony

not having a go at you but i need more info cause i still can't see the
right "f"ing
option on the toolbar
"moi" wrote:

If you can see a TextBox on your controls toolbar, then I don't see why
there isn't a PictureBox.
Of course there was no other info - a TextBox is for text, that's why it's
called a TEXT-box.
So a PictureBox is for pictures.

'Does it exist??'

What do you think?
That I wrap my pictures in a textbox, and buy my bicycle at the butcher?


"Anthony" schreef in bericht
...
Want to insert various pictures into a set spot on a template. In order
to
make it simple and quick would be great if you could set a box to drop
picinto similar to text box.

Got a reply suggesting a Picture box with no other info. I can't find this
as such. Does it exist??

anthony





moi

Are you looking at your default toolbar on top of the screen, or are you
looking at your Controls Toolbar, 'cos that's the one you need.

Here's an empty sheet with 1 picturebox:
http://www.geocities.com/smplprgrsrc...picturebox.zip


"Anthony" schreef in bericht
...
not having a go at you but i need more info cause i still can't see the
right "f"ing
option on the toolbar
"moi" wrote:

If you can see a TextBox on your controls toolbar, then I don't see why
there isn't a PictureBox.
Of course there was no other info - a TextBox is for text, that's why
it's
called a TEXT-box.
So a PictureBox is for pictures.

'Does it exist??'

What do you think?
That I wrap my pictures in a textbox, and buy my bicycle at the butcher?


"Anthony" schreef in bericht
...
Want to insert various pictures into a set spot on a template. In
order
to
make it simple and quick would be great if you could set a box to drop
picinto similar to text box.

Got a reply suggesting a Picture box with no other info. I can't find
this
as such. Does it exist??

anthony







Anthony

i found that before and have revisited it but when it appears on the
worksheet how do I drop a picture from file ( ie a photo ) into it.

"moi" wrote:

Are you looking at your default toolbar on top of the screen, or are you
looking at your Controls Toolbar, 'cos that's the one you need.

Here's an empty sheet with 1 picturebox:
http://www.geocities.com/smplprgrsrc...picturebox.zip


"Anthony" schreef in bericht
...
not having a go at you but i need more info cause i still can't see the
right "f"ing
option on the toolbar
"moi" wrote:

If you can see a TextBox on your controls toolbar, then I don't see why
there isn't a PictureBox.
Of course there was no other info - a TextBox is for text, that's why
it's
called a TEXT-box.
So a PictureBox is for pictures.

'Does it exist??'

What do you think?
That I wrap my pictures in a textbox, and buy my bicycle at the butcher?


"Anthony" schreef in bericht
...
Want to insert various pictures into a set spot on a template. In
order
to
make it simple and quick would be great if you could set a box to drop
picinto similar to text box.

Got a reply suggesting a Picture box with no other info. I can't find
this
as such. Does it exist??

anthony







moi

Right mouse click on the PictureBox, then Properties, and there you click
Picture and browse your disk.

If a right click is not working, then you're not in 'edit mode' and you'll
have to click the blue button on top of the Control toolbar.



"Anthony" schreef in bericht
...
i found that before and have revisited it but when it appears on the
worksheet how do I drop a picture from file ( ie a photo ) into it.

"moi" wrote:

Are you looking at your default toolbar on top of the screen, or are you
looking at your Controls Toolbar, 'cos that's the one you need.

Here's an empty sheet with 1 picturebox:
http://www.geocities.com/smplprgrsrc...picturebox.zip


"Anthony" schreef in bericht
...
not having a go at you but i need more info cause i still can't see
the
right "f"ing
option on the toolbar
"moi" wrote:

If you can see a TextBox on your controls toolbar, then I don't see
why
there isn't a PictureBox.
Of course there was no other info - a TextBox is for text, that's why
it's
called a TEXT-box.
So a PictureBox is for pictures.

'Does it exist??'

What do you think?
That I wrap my pictures in a textbox, and buy my bicycle at the
butcher?


"Anthony" schreef in bericht
...
Want to insert various pictures into a set spot on a template. In
order
to
make it simple and quick would be great if you could set a box to
drop
picinto similar to text box.

Got a reply suggesting a Picture box with no other info. I can't
find
this
as such. Does it exist??

anthony









Anthony

thanks

still end up with the picture needing resizing to fit the box

is thee somewhere to enable so that regardless of differens photos
properties they resize to drop the entire image into the box. I'll clarify
I'm using this for a cattle sale catalogue therefore the pictures are photos,
JPEG

"moi" wrote:

Right mouse click on the PictureBox, then Properties, and there you click
Picture and browse your disk.

If a right click is not working, then you're not in 'edit mode' and you'll
have to click the blue button on top of the Control toolbar.



"Anthony" schreef in bericht
...
i found that before and have revisited it but when it appears on the
worksheet how do I drop a picture from file ( ie a photo ) into it.

"moi" wrote:

Are you looking at your default toolbar on top of the screen, or are you
looking at your Controls Toolbar, 'cos that's the one you need.

Here's an empty sheet with 1 picturebox:
http://www.geocities.com/smplprgrsrc...picturebox.zip


"Anthony" schreef in bericht
...
not having a go at you but i need more info cause i still can't see
the
right "f"ing
option on the toolbar
"moi" wrote:

If you can see a TextBox on your controls toolbar, then I don't see
why
there isn't a PictureBox.
Of course there was no other info - a TextBox is for text, that's why
it's
called a TEXT-box.
So a PictureBox is for pictures.

'Does it exist??'

What do you think?
That I wrap my pictures in a textbox, and buy my bicycle at the
butcher?


"Anthony" schreef in bericht
...
Want to insert various pictures into a set spot on a template. In
order
to
make it simple and quick would be great if you could set a box to
drop
picinto similar to text box.

Got a reply suggesting a Picture box with no other info. I can't
find
this
as such. Does it exist??

anthony










Anthony

don't woory seen the option for sizing picture

Thanks for your help

anthony

"moi" wrote:

Right mouse click on the PictureBox, then Properties, and there you click
Picture and browse your disk.

If a right click is not working, then you're not in 'edit mode' and you'll
have to click the blue button on top of the Control toolbar.



"Anthony" schreef in bericht
...
i found that before and have revisited it but when it appears on the
worksheet how do I drop a picture from file ( ie a photo ) into it.

"moi" wrote:

Are you looking at your default toolbar on top of the screen, or are you
looking at your Controls Toolbar, 'cos that's the one you need.

Here's an empty sheet with 1 picturebox:
http://www.geocities.com/smplprgrsrc...picturebox.zip


"Anthony" schreef in bericht
...
not having a go at you but i need more info cause i still can't see
the
right "f"ing
option on the toolbar
"moi" wrote:

If you can see a TextBox on your controls toolbar, then I don't see
why
there isn't a PictureBox.
Of course there was no other info - a TextBox is for text, that's why
it's
called a TEXT-box.
So a PictureBox is for pictures.

'Does it exist??'

What do you think?
That I wrap my pictures in a textbox, and buy my bicycle at the
butcher?


"Anthony" schreef in bericht
...
Want to insert various pictures into a set spot on a template. In
order
to
make it simple and quick would be great if you could set a box to
drop
picinto similar to text box.

Got a reply suggesting a Picture box with no other info. I can't
find
this
as such. Does it exist??

anthony










moi

No problem. Glad your doin' fine.


"Anthony" schreef in bericht
...
don't woory seen the option for sizing picture

Thanks for your help

anthony

"moi" wrote:

Right mouse click on the PictureBox, then Properties, and there you click
Picture and browse your disk.

If a right click is not working, then you're not in 'edit mode' and
you'll
have to click the blue button on top of the Control toolbar.



"Anthony" schreef in bericht
...
i found that before and have revisited it but when it appears on the
worksheet how do I drop a picture from file ( ie a photo ) into it.

"moi" wrote:

Are you looking at your default toolbar on top of the screen, or are
you
looking at your Controls Toolbar, 'cos that's the one you need.

Here's an empty sheet with 1 picturebox:
http://www.geocities.com/smplprgrsrc...picturebox.zip


"Anthony" schreef in bericht
...
not having a go at you but i need more info cause i still can't see
the
right "f"ing
option on the toolbar
"moi" wrote:

If you can see a TextBox on your controls toolbar, then I don't see
why
there isn't a PictureBox.
Of course there was no other info - a TextBox is for text, that's
why
it's
called a TEXT-box.
So a PictureBox is for pictures.

'Does it exist??'

What do you think?
That I wrap my pictures in a textbox, and buy my bicycle at the
butcher?


"Anthony" schreef in bericht
...
Want to insert various pictures into a set spot on a template.
In
order
to
make it simple and quick would be great if you could set a box to
drop
picinto similar to text box.

Got a reply suggesting a Picture box with no other info. I can't
find
this
as such. Does it exist??

anthony













All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com