Listboxes.

[Mukesh Jain]

Dear Excel Community,

I need to build a invoice format for my excel worsheet.I need a way to add a
listbox.I already know a way of doing it but that doesn't hide the items of
listbox.It just shows a listbox with the values.When i select a value,even
the values in the listbox changes.I need to overcome both these
shortcomings.

Also if I delete the data in the cells,even the formula gets deleted.I need
the formulas to stay hidden permanently in a worksheet.So that i can open a
copy and feed data each time and save it as another file.

Regards,
Mukesh

 

[Frank Kabel]

Hi
not quite sure what you're trying to achieve but for your listbox you
may have a look at data validation (Menu: 'Data - Validation - List').
This would be the easiest way to create a listbox on your worksheet.
Have a look at
http://www.contextures.com/xlDataVal01.html
for further information

 

[Mukesh Jain]

Already tried this method from ur prev post...But has got a few
niggles...like the listbox items changes dynamically.

Also can somebody help me out with the formula embedding thing....If I
delete the data in the cells,even the formula gets deleted.I need the
formulas to stay hidden permanently in a worksheet.So that i can open a
copy and feed data each time and save it as another file.

Regards,
Mukesh jain

 

[Tom Ogilvy]

You can have cells locked or unlocked and this is enforced by protecting the
sheet under the tools menu. You seem to have some misconception that
formulas and the values displayed in cells are separate. They are not. You
can't delete or clear the contents of a cell and have a formula remain. You
would need to set up your formulas so that they do not display a value until
you want them to. You might have them all constructed as If statements
refering to a cell that holds a value

=if(A1=1,"",currentformula)

So if the cell is locked, the sheet protected and the formula set up as
shown, you can make the cell appear blank.