By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,623 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,623 IT Pros & Developers. It's quick & easy.

Text/Message or Buttons help (new to VB)

P: 2
The Below is the macro I am currently using to work out difference between data on a quartre on quarter basis, this works, however what I would like to do is place a button if possible, where it pops up 'Please see Failure report, Click here, then I would like this button to flick to another worksheet when the button or text box is pressed

As I am new to Macros and Visual basic, I dont know if this is possible, can anyone out there offer any assistance.

If Abs(Worksheets("PreviousData").Range("K2")) <> 0 Then
If Abs(Worksheets("PreviousData").Range("J2") - Worksheets("PreviousData").Range("K2")) / Abs(Worksheets("PreviousData").Range("K2")) * 100 >= 100 Then
If Abs(Worksheets("PreviousData").Range("J2") - Worksheets("PreviousData").Range("K2")) > 50 Then
Worksheets("QLTI&E").Range("K72").Value = "Please see failure report - click here"
Worksheets("Failure Report").Range("A5").Value = "Box 4071 - The difference between quarter on quarter exceeds 100%"
End If
Worksheets("QLTI&E").Range("K72").Value = "Please see failure report - click here"
Worksheets("Failure Report").Range("A4").Value = "Box 4071 - The difference between quarter on quarter exceeds 50m"
End If
End If
Nov 29 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.