Adding on data automatically

  • Thread starter Thread starter ginja
  • Start date Start date
G

ginja

After solving one problem, i was wondering if theres a posibililty o
adding on details like name, address etc on to the bottom of
list/table. I have tried recording my own macros but it needs to b
able to add the data to where there isnt any at the moment. I hope yo
understand, and if its easier...just use one field, and i'll try an
develop it. Thanks in advance
 
Excel has a built-in forms manager for data lists. Go to Data>Forms and
start it. It does all you need automatically.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
ok, thanks for that.....but is there any way you can do a macro so i
brings up the forms box?

i know it sounds lame, but my project "must be easy to navigate around
 
ok, i know i seem really lame but i tried that before and it comes u
with 'Run time error '1004'". and when i enter VBE it highlights tha
line......i do have entered data and the macro at the mo looks like:

Sub OpenForm()
'
' OpenForm Macro

'

'
Range("B17").Select
ActiveSheet.ShowDataForm
End Su
 
Hi
this only works, if you have database headings in row 1. Try the
following
Sub OpenForm()
Range("A1").Select
ActiveSheet.ShowDataForm
End Sub

In A1 should be a column heading. You can test this: Select cell B17
manually and try to open this dialog. You probably will get an error
 
ok thanks, but why should it matter which column/row it's in if i stat
it? its annoying coz i lose the look and feel of my datasheet and als
have to change all equations etc

:mad
 
Hi
Excel / this dialog checks if the cursor is in a valid database
structure. You don't have to change the layout of your spreadsheet.
Just place the cursor in your macro in a cell inwhcih the manual
invoking would work also.
 
:-)
don't put this anythere :-). You just have to place the cursor within
the macro to a valid cell for this dailog to work. Test which cell is
o.k. by manual opening the dialog in the 'Data' menu. Best way: place
the cursor in your heading row
 
it lets me open the form menu anywhere in my table, but the macro neve
works, and comes up with that error message
 
Hi
tested the code
Sub OpenForm()
Range("A1").Select
ActiveSheet.ShowDataForm
End Sub

again and it works for me. Try the following: Record a macro for
opening this dialog
 
well thanks for the help but thats what i came up with before, it doesn
like the data not being in a1 so that may be my only choice in th
end.

thanks for the 2nd time in a week though fran
 
Back
Top