View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
BigPig
 
Posts: n/a
Default using list box to edit or select data

Thanks for your input.

1. I'll do some more research on a macro that'll just save my worksheet etc...

2. That's what I figured, but I had to ask. The worksheet I was referring to
had a macro that allowed the user via properties to change the font,
etc...Unfortunately it didn't stay that way after exiting the list/combo box.
What it did was after double clicking on a list box (data validation) a list
box from control forms would appear in the cell tha you selected, and the
data you typed in would be as you formatted it in properties. But afterward
clicking on another cell it would revert to the original formatting found in
data validation. It's not a biggy, just something that I'll have to play with
some more.

3. The reason for the quesiton is that the form is about 300kb, which would
be saved many times (once for each applicant). Since that kind of space would
add up after awhile, I was trying to think of a better way of saving the
file. But I think if I get rid of some of the control box list boxes, that
will save some space.

Form flow is a databased application that has thousands of forms, and allows
the user to save the data not in the form but in its database files. All a
user would have to do is to save the data, or if they wanted to review the
form from information saved to the database they could do that too.

4. You are right about access. I should do that, it's just that I find excel
much more user friendly, and easier to set up. I have made a couple of
databases in access, and it takes forever and a day to set up. Plus I am a
fan of numbers, and excel's ease of use (most of the time), and I want to
learn more about excel before I move on to access. Nonetheless you are right
about access.

Thanks very much for your advice!

---Mike---