Hello imTrying to use the dget formula in a vba sub
my data base contains the folowing exemple
name type discription
28 days horror $#%#@
this is what i have so far but it dont work
sub get movie
name = inputbox ("enter movie name")
sheet("movielist").activate
moviedata = application.worsheetfonction. _
dget(movielist,petelist!b3,name)
msgbox moviedata
end sub
been trying to figure it out for a will now if you can help it would be very apreciated..
my data base contains the folowing exemple
name type discription
28 days horror $#%#@
this is what i have so far but it dont work
sub get movie
name = inputbox ("enter movie name")
sheet("movielist").activate
moviedata = application.worsheetfonction. _
dget(movielist,petelist!b3,name)
msgbox moviedata
end sub
been trying to figure it out for a will now if you can help it would be very apreciated..