findvalue.offset0

I’m new to VBA and I’ve run across a problem and I haven’t been able to solve searching the internet. I have a range of data (“B5:B120”) that contains numeric value and has filled and blank cells. Some of the cells have the same value. I am trying to find all the cells in that range that...

I have created a directory and it works great until you have it open with other documents... So I need to limit it to only this workbook but with the different types of script below I'm not sure how... It's not as simple as just placing ThisWorkbook in front of it... Any assistance on getting...

Hello friends, I have created a userform which has search button set with criteria SUBJECT in column A which is working perfectly ok. I added 'INSERT IMAGE' command button to create jpg file with "incoming letter reference no." which is column D. It is nicely creating a jpg file with...

Hi I wonder f someone could provide me with some help and advice please? I have a userform to add, edit and delete data on a worksheet. It all works fine apart from the date format changes when the userform is edited. When I change any of the controls in the userform (name etc) the dates...

Basically a listbox on a userform that when row is select for edit it displays on the Textbox as text but with the date it display as number 42516 instead of date format has in the cell 12/10/2017 am using DTPicker Kindly appreciate any idea out there as i was stuck with this for a bit...