I'm iterating through values on a combobox control and at each value I'm
copying the picture into Powerpoint. The code changes the combo value to
reflect data changes on the sheet but it doesn't show the value change on the
combo box
--
~Your Friend Chris
http://myvbastuff.blogspot.com/
thinking out loud

If the combobox is on a userform, maybe adding:
me.repaint
would help

If the combobox is placed on a worksheet, maybe adding
do Events
would help

Or turning off screenupdating, then turning it back on.

Or minimizing the window and resizing (maximizing?) would help....Sometimes,
finding a solution can be a pain.

vbasean wrote:
>
> I'm iterating through values on a combobox control and at each value I'm
> copying the picture into Powerpoint. The code changes the combo value to
> reflect data changes on the sheet but it doesn't show the value change on the
> combo box
> --
> ~Your Friend Chris
> http://myvbastuff.blogspot.com/
> thinking out loud

--

Dave Peterson

Maybe if I added some more info it might help.

we're changing the value of the combobox and doing a copypicture and when we
copypicture, the refresh occurs with the data but it's not reflected in the
combo box value.


--
~Your Friend Chris
http://myvbastuff.blogspot.com/
thinking out loud


"vbasean" wrote:

> I'm iterating through values on a combobox control and at each value I'm
> copying the picture into Powerpoint. The code changes the combo value to
> reflect data changes on the sheet but it doesn't show the value change on the
> combo box
> --
> ~Your Friend Chris
> http://myvbastuff.blogspot.com/
> thinking out loud

We'll give these a try and see what happens.

Thanks

--
~Your Friend Chris
http://myvbastuff.blogspot.com/
thinking out loud


"Dave Peterson" wrote:

> If the combobox is on a userform, maybe adding:
> me.repaint
> would help
>
> If the combobox is placed on a worksheet, maybe adding
> do Events
> would help
>
> Or turning off screenupdating, then turning it back on.
>
> Or minimizing the window and resizing (maximizing?) would help....Sometimes,
> finding a solution can be a pain.
>
> vbasean wrote:
> >
> > I'm iterating through values on a combobox control and at each value I'm
> > copying the picture into Powerpoint. The code changes the combo value to
> > reflect data changes on the sheet but it doesn't show the value change on the
> > combo box
> > --
> > ~Your Friend Chris
> > http://myvbastuff.blogspot.com/
> > thinking out loud
>
> --
>
> Dave Peterson
>