DYNAMIC XY SCATTER CHART EXCEL CODE

If I use the delete key to delete the contents of a cell, then it gets deleted. If I'm in the excel window, I can click alt on the keyboard and the shortcut keys for the menu come up, but I can't go deeper than that by clicking the letter shortcuts, they do nothing. When it gets locked up like this, I can still do anything in the VBE (edits cells, run macros, etc.) with no problems. Still having trouble, and the same thing is happening with this workbook on two different computers, so I don't think it's a hardware, or OS specific issue. The only way I've been able to get back to normal is by force closing excel altogether and re-opening. If I go into the VBE, I can manually run procedures and they all work fine. I've made sure that screenupdating is turned back on at the end of every procedure. I can't think of anything in my macro that would have these kinds of effects. I don't understand what's going on at all. So if I press 's' it will input 'ss' into the cell, and then when I press enter it will auto-move to the next cell down, but nothing ends up getting saved into the previous cell. Then it gets really strange - when I have a cell highlighted and press any key to input text, it gets duplicated. BUT, if I use the keyboard arrow keys, I can see that the active cell selection moves accordingly. When I click anywhere (trying to select a cell, or an excel menu item.clicking anywhere in excel) I'll get the a 'ding' system sound and nothing will happen. Occasionally it will run as expected but as soon as the macro ends, excel becomes unresponsive to mouse-clicks. I have a fairly lengthy macro that works perfectly most of the time.

I've been having a strange problem lately. Posted this on the Ozgrid forums, but haven't gotten any help yet, so I thought I'd try here too! I have uninstalled the addin and so far so good, but I cannot categorically say that this was the cause.Р”Вoesn't seem to cover the issue I describe

DYNAMIC XY SCATTER CHART EXCEL CODE

The only thing I could suspect was I think this started around about the time I installed xlDennis' code library. Some days I can work without this problem, other days I encounter this 2 or 3 times. I can't work out when it goes into this mode. Clicking save just invokes the same msgbox again. If I close the workbook I am prompted to save, close without saving or cancel. Using Save As doesn't either do anything, the dialog is not displayed and if I am doing via the File menu then the File menu is exited and the previous ribbon tab is displayed (i.ethe one I was on before clicking 'File') Found others suffering the same but haven't found any conclusive answer yet.Р”В®very so often when I attempt to save a file, (including save as), Excel won'r let me. could you guys document in this topic when you would/must use the exit rather than the afterupdate event (or vice-versa). Changing the event from exit to afterupdate corrected this. I then discovered that the exit events didn't kick in if, instead of tabbing out of the field, I deliberately placed focus in a control elsewhere on the form. This resulted in me using the exit event for all except the last textbox in the frame that used afterupdate instead If you tabbed out of the last textbox in the frame, the exit event never kicked in (this is documented in other topics but took some time to find). I started off using the exit event but ran into 2 problems. The user enters a currency value and once they leave the control, then a protected textbox next to it shows the corresponding value in SEK. I have a userform with frames containing textboxes. Thought I'd kick off with my 2 cents' worth. Thought I'd start this topic since there seem to be a number of topics where the answer seems to be to use one of the above rather than other. P.S for the calender drop down on the main page, i'm using 'microsoft time & date picker 6.0)

If just someone could point me in the right direction, i would be appreciate it so much words can't express!!! I am volunteering for a non profit organization and trying to create a reservation system for the rooms that they have - kind of like hotel software, but in excel (i did a similiar thing in college but for plane seats)Р”В¬opy all of the info from the main page to the guest lit (a new row each time).Р”Р‡rom the guest list to the Gannt chart - i did a few tutorials on dynamic gantt charts using conditional formatting but cannot get them to work when based on data on a different worksheet.Р”Р‡inaly is there a way to check for availabilty on any given date?

So i'm having to re-learn 99.9% of everything i once new. Firstly i haven't used excel to a great extent since my college days.

Dynamic xy scatter chart excel