ive got this bit of code im not sure if ive deleted something without realising but its for my search button on my user form and keeps returning a message about my item not being found when its clearly on my sheet, could someone please advise
see the other thing i want to try and do is edit the record and put it back in the same place.
Please Login or Register to view this content.
Your code uses the activesheet to search on. Is the activesheet the one with your data on it?
ahh its supposed to lookup on worksheet "Expences"
i just tried it on the active sheet and still same problem
then you need to post example as the quick test I did worked
here you go
link to file
why dropbox? forum has attachment capabilities
normal date format confusion when using find.
Please Login or Register to view this content.
where on userform is that
it was quicker i have dropbox on desktop and its quicker just to link to files from here....is it not allowed?
how can it be fixed please
ty for your help can the code be amended for my save changes so i can edit the record and put it back with it was?
where is what?where on userform is that
well it's quicker for me to click the attachment that spawn off to dropbox and download it from there.it was quicker i have dropbox on desktop and its quicker just to link to files from here....is it not allowed?
I posted revised code at post #8, did that not work for you?how can it be fixed please
not to worry with regards your last post, could you answer my last one please ty
and could you please point me in the direction of being able to cycle multiple items on selected date please.
to save your changes simply do the reverse.
Locate the row and then output textbox values to cells rather than read from them.
If you have records with shared dates you will either need to alter you UI to allow for selection of specific matching record. Or output the search information to a secondary useform in order to allow the user to select specific record and then populate your main userform fields.
dont understand do the reverse?
Read from sheet
Write to sheetPlease Login or Register to view this content.
Please Login or Register to view this content.
does that get put under the same button or my save button and is it just that code or the whole code
i put this in my save button and throws up error on sheets
Please Login or Register to view this content.
Last edited by flyinghigher2011; 07-18-2013 at 01:19 PM.
sorted never mind thank you for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks