Search results

Hi Luke, very new to using VBA, for some reason I thought that the MsgBox Format was the main element in ensuring that the code recognised the input as a date. Understand now that by defining start_dt and end_dt as dates that the code would handle any input as such. Your suggestion works...

Hi, I need a macro that will prompt the user to enter a start date in cell “O2” and then a end date in cell “O3” via a message box that will only except the date if entered in the format “dd mmm yyyy”. I think I have the basics below, but I want to add the following error handling: - If...

Hi, I've come across this problem to in the same scenario of running weekly reports where new data needs to be copy-pasted to replace old data. As Hui mentioned the #REF! error occurs mostly when a cell, range, sheet or file that formula are linked to is deleted. Therefore, I found that I had to...

Thanks for your response Luke. I changed the graph to plot percentage change and fixed the min/max values for the Y axis. Your right this looks better, shows the changes and helps to compare as I select items from the List Box. Cheers, Pav

Hi All, I'm Pav from London. Joined today as I frequently search solutions to Excel problems. Looking forward to learning more. Thanks.

Hi, I have the below data set (comma separated). Having created a line graph I have the below values in the Source Data dialog box on the Series tab (assuming this is pasted in range A1:B32 on Sheet1). Looking at the Format Axis dialog box the Y axis minimum is zero (auto ticked). However for...