Hey
I try to run attached excel file which store customer data (Address).
But I am getting "Runtime Error # 424 - Object Required"
I Am really confused about it.
Can u please Help me?
Regards
Charles
Hey
I try to run attached excel file which store customer data (Address).
But I am getting "Runtime Error # 424 - Object Required"
I Am really confused about it.
Can u please Help me?
Regards
Charles
You have disabled "Aip.Txt...
I cannot enter or save the data.
When I open the form it give error mesg " Invalid Row..." I cannot go further.
Please help me.
Regards
Charles
ebin
close but no banana
Now I am geting Error # 13
Type Mismatch..
which line as it the example works we for me
Sir,
It shows me the error:
Runtime Error # 13
Type mismatch...
This error shows in the line no. 126 Column 1
I attach the corrected workbook.
can u help me?
Regds
charles
can you copy the line?
There is bold line the below code
this line shoe error Runtime Error 13, Type mismatch
is CustomerID.Text = FormatNumber(Cells(r, 1), 0)
Please Login or Register to view this content.
strange it runs ok for me
change from
toPlease Login or Register to view this content.
text to number format?Please Login or Register to view this content.
Now i am getting error the same
Runtime error 13 - type mismatch
@ line DateAdded.Text = FormatDateTime(Cells(r, 6), vbShortDate)
Please Login or Register to view this content.
hi ebin
hmmm..
for the moment try
a/. adding some values to the date column
or
b/.
change the code to
this will disable the line for the momentPlease Login or Register to view this content.
my master
thank you so much. you are so greatful.
i have learned from so much.
the format of date in my sheet is not correct. i think.
otherthan that it is working.
thank you
regards
charles
no master my friend
just an average punter - thanks for posting you question and glad you are learning
dont forget to change your thread prefix to solved
Sir,
I need to enter the address of the customer in that form.
Can I? When i try to enter the contact i cannot.
Please
Regards
Charles
master here you go
ebin
dont forget to change the thread prefix to solved as it will help others search for a silimar answer
Depending on the existing situation
But do not use a loop.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks