I think i should be able to do what i want with the third link you gave me.
I've got one question however. I want people to add a number. Then i've got
an external excel file with a bunch of info. Basicly i want people to enter
one number which is following by excel automaticly filling in the rest of the
info.
For example:
I've got one external spreadsheat ( ~ 10000 rows).
With the following info:
A
France - Capital Paris - French
The Netherlands - Capital Amsterdam - Dutch
I want people to be able to pick 'The Netherlands' ( or type it). Followed
by the script creating the exact same row. (Normally i could do this using
offset to find 'The Netherlands' or use vlookup. I want this to be automated.
Any further help?
Greets,
Gunti
"Dave Peterson" wrote:
There's not much detail here, but it sounds like you want to design a data entry
input form?
If yes, you may want to look at excel's built in version:
Data|Form (in xl2003 menus)
If that's not enough...
You could look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm
The source code is available for a small fee ($20 USA, IIRC). So you can modify
it as much as you want.
And if you want to design your own:
Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html
Gunti wrote:
Hi,
I want to create a macro that does the following:
I want people to press a button (for example). Then enter a number (in a
textbox for example), whereafter the macro checks where the next empty row
is. Then fills this row with info found by VLookup() (or Offset()). Basicly i
want to use this to add info to my excel sheet, not manually putting it in.
Any info on how to do this?
--
Dave Peterson