CheckBox Control Copy and Paste

[iseman002]

I am new to the advance functions of Excel.

I have an inventory sheet running. I want to place a check box next t
each line and once the box is checked, it copies the 3 or 4 differen
columns in that one row(i.e.: SKU#, Description, Manaufactor and Curren
Quantity) to another sheet and prompts you to enter the amount to order
As I check different items, I want it to place that information on th
next line generating a running order list. I have about 400 items in m
inventory and just want to go through it and just check off what I nee
to order. Hope this makes sense.

Thank

 

[GS]

I am new to the advance functions of Excel.

I have an inventory sheet running. I want to place a check box next
to each line and once the box is checked, it copies the 3 or 4
different columns in that one row(i.e.: SKU#, Description,
Manaufactor and Current Quantity) to another sheet and prompts you to
enter the amount to order. As I check different items, I want it to
place that information on the next line generating a running order
list. I have about 400 items in my inventory and just want to go
through it and just check off what I need to order. Hope this makes
sense.

Thanks

You can format a column where the checkboxes should with Wingdings2
font, then use the Worksheet_BeforeDoubleClick event to place a
checkmark in the cell that was double-clicked. Just arrange the
height/width of the cells in that column to reasonably resemble a
checkbox, and include a light border around them. Give the column a
defined name with local scope so coding is easier managed.
Double-clicking will toggle the checkmark on/off. On can prompt for
Qty, Off can prompt to delete from the order sheet or just set Qty to
zero. (Setting to zero allows showing pricing of the item, but not
including that in the total)

If you need help with this, put your file on a public download site and
post back to here a link so we can look at it. Be sure to put an email
address in the file so we know where to send it...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion