- ScrollBar is still activated when pressed > 2 times in a row
Your code appears to work fine if you put it in the Scrollbar'sGotFocus event.Private Sub ScrollBar1_GotFocus()With ScrollBar1.Min = 1.Max = 30.LargeChange = 5.SmallChange = 1End WithRange("A1").SelectRange("A1") = ScrollBar1.ValueEnd SubRegards,Vic Eldridge0000_AAAA_0000 <0000_AAAA_0000....
- Help with formula
I am looking for help with the following formula =IF(AND(H45<$B$1,A45<>207003),($B$1-H45)/(H45-G45)*I45,($B$1-H45-($B$1-H45)/7)*2) I want to have something else onto the formula which says that if the entry is less than 0 then enter "" Any ideas? Thanks...
- Customize/ Hide data in pivot table
I have a pivot table in following layout: Status(firm order/ forecast) (column field) firm order (column) Forecast order (column) Product (row field) Sum of QTY Sum of Order Sum of QTY Sum of Order (data) I want to show per product, the sum of qty and sum of order for firm order; and sum of qty...