creating a drop down list of pricing
 

I plan on buying a PDA for work very soon and I am using my pc at th
moment to create a spreadsheet that has a number of rows within
column that each should have a drop down box to select a price. I wan
the prices to be different and I dont know visual basic at all and
don't want the excel file to be too big as the pda can only handle s
much. I also want to create a check box where i can use the stylus pe
and literally tick that the stock is there and put a x where it is no
with the pen...any suggestions please .........!!!!!!!!!!!!!!

in the attachment the blue is for the price and the red is for th
check boxe

Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51478
--
Message posted from http://www.ExcelForum.com

creating a drop down list of pricing
 

Better check what the capabilities of pocket excel are. Pocket excel and
excel are two completely different products (like outlook and outlook
express). Pocket excel has pretty limited capabilities. I doubt it
supports data validation which it appears you are describing or controls on
the worksheet.

--
Regards,
Tom Ogilvy

"Deon " wrote in message
...
I plan on buying a PDA for work very soon and I am using my pc at the
moment to create a spreadsheet that has a number of rows within a
column that each should have a drop down box to select a price. I want
the prices to be different and I dont know visual basic at all and I
don't want the excel file to be too big as the pda can only handle so
much. I also want to create a check box where i can use the stylus pen
and literally tick that the stock is there and put a x where it is not
with the pen...any suggestions please .........!!!!!!!!!!!!!!

in the attachment the blue is for the price and the red is for the
check boxes

Attachment filename: book1.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=514789
---
Message posted from http://www.ExcelForum.com/

creating a drop down list of pricing
 

Here is an example on drop down boxes:
www.contextures.on.ca/xlDataVal02.html

"Deon " wrote in message
...
I plan on buying a PDA for work very soon and I am using my pc at the
moment to create a spreadsheet that has a number of rows within a
column that each should have a drop down box to select a price. I want
the prices to be different and I dont know visual basic at all and I
don't want the excel file to be too big as the pda can only handle so
much. I also want to create a check box where i can use the stylus pen
and literally tick that the stock is there and put a x where it is not
with the pen...any suggestions please .........!!!!!!!!!!!!!!

in the attachment the blue is for the price and the red is for the
check boxes

Attachment filename: book1.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=514789
---
Message posted from http://www.ExcelForum.com/