disappear

When I run the following code the values in the called sheet populate into the list box. However, when I try to click them on the user form sheet, the values disappear and I get a blank box. Can anybody help? Thanks! Private Sub Product_Change() Application.EnableEvents = False Product.Clear...

Hi. I'm new to Excel, using Office Professional Plus (2013). Within my spreadsheet, I have a series of progressive dates to be used in as a timeline. Ultimately, what I need to accomplish is that when I change one date, all the proceeding entries update according to my timeline criteria (in...

Hi, I have a large flow diagram where I've drawn arrows by inserting shapes. When I scroll around sometimes the lines are there, sometimes not - I have to keep on scrolling around until they turn up. Is this a bug? Or is there a way round this? I'm using Excel 2007 with SP3 It is really...

Hi There, I am running a macro that is causing my active cell indicator to disappear. In term of clicking around, I can still select cells, highlight cells and type formula's into cells. However, the black border that surrounds an active cell doesn't work. My file is completely macro driven and...

I have a simple sheet with three ActiveX controls (one for each report) and a pivot table. The Pivot tables shows a list of parts associated with a charge unit. The user selects the charge unit in the pivot table then clicks the ActiveX control for the report they want. Sometimes the user...

I am working in Office 2010 (but I also have Office 2007 available). I have a spreadsheet with 20 columns and 1300+ rows. Some random page breaks have appeared. When I reset them using the Reset command, it looks great. I save the file and close it but when I reopen the file, the old page...

I haven't seen an answer to this, but if its been already posted, just point me in the direction... I have a macro-enabled 2007 excel spreadsheet that includes both charts as objects in sheets as well as charts as separate sheets (the only macro in the workbook has nothing to do with charts)...