Thread: Data entry form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Crowbar via OfficeKB.com Crowbar via OfficeKB.com is offline
external usenet poster
 
Posts: 128
Default Data entry form

You are going to have to learn a little about VB first but this is what you
need to do

Access the VB editor ALT & F11

Create a userform and then add the required field for your data, do this by
creating a number of textboxs onto your userfom and stick a command button
onit.

Insert a code like this within the userform, to access where to enter code
double click the userform

Sub commandbutton1_click

Rows("1:1").Select
Selection.Insert Shift:=xlDown
range("A1).value = textbox1.value

end sub

I know its not much but it will give you a start

If you have any problems contact me at




Within Excel create

--
Message posted via
http://www.officekb.com