Data Update Form

P

Profairy

Dear All,

I'm fairly new to VBA and have only ever used Access VBA before. I'
trying to build a form that will enable the user to search the data o
my "Raw Data" sheet and then display these relevant rows in some sor
of sub form on the form? Is this possible like it is in Access?

Basically i need a combo box to place my search criteria in (this i
from a list of set choices) and then when i click the search button i
will bring back all data rows found so that they can edit it. Then
need to update this data and be able to click another button to get i
updated back in to the main data sheet.

Sorry it's hard to explain
 
K

keepitcool

have a look at autofilter or advanced filter.

unlike access, it's not easy to create an "updatable"
userform. instead you'll probably just work in the sheet itself.

You can then use a simple userform to set the the filter settings,
or you could do it all on the sheet itself using data validation
to achieve your dropdowns.



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
Top