pressed

I'm trying to find a way to clear a Combobox value if the delete key is pressed but it's not doing what I need. What I want it to do is if the user presses the delete or backspace key just clear the Combobox value but what I have so far is clearing the Combobox automatically after every...

Hello, please can you help me with the code below that works great but i just wanted the data in the form to clear once the add button has been pressed and all data has be transferred to the other sheet, is there any way for it to 'Clear' once the button is pressed? please can you help me...

Hi all, Could I please ask if it may be possible to have a button to toggle between the following hide/unhide columns Hide J:M Unhide O:AB Then if pressed again Unhide J:M Hide O:AB Then if pressed again revert back to the start many thanks for any help

Excel 2010 Win 8 Pro Greetings to all, I am including some stripped-down, simplified code that illustrates a problem that I'm having with a form. This little form contains only a checkbox and 3 textboxes, with the checkbox having TabIndex 0, and the first, second and third textboxes having...

Hi, as an example below Sub ontimer() MsgBox ("Hello") Application.OnTime Now + TimeValue("00:01:00"), "ontimer" End Sub when executed from button, displays the message then 1 minute later executes it again. Now if the button is pressed more than once, it is looping more than once. So if i...

So I have a few different buttons in a modeless vba form Each of these buttons runs ado queries on an access database. My issue is that 1 button can be pressed and while its still running and loading the query data another button can be pressed which tries to run another query. Is there anyway...

I'm using the following code to provide the user with a Print Preview/Print Settings page: Private Sub PrintPage1Button() 'Set up Print Preview With ActiveSheet.PageSetup .PrintArea = "B1:T56" .Orientation = xlLandscape .LeftMargin = Application.CentimetersToPoints(0.5)...

Hi, Would anyone be able to tell me how to make the following work: I'd like to be able to click a certain cell - let's say B5 - and then every time that cell is pressed, a list of the time and dates appear descending down another column (column J for example)? Any response would be most...

I have created a macro button on the outlook and I'm trying to have it do the following and nothing is working. Much help is needed. When pressed a text box should show up and have 5 choices to choose from. whatever choice is selected will add that corresponding email to the cc line Problems...

I've made a togglebutton on the ribbon in Excel 2007, but I don't know how to check whether the button is pressed or not in a module. Does anyone know how to handle this problem?

Hi. I have table with many rows of data, and I'd like to have certain cells copied in the same row when data is entered in a specific column in that row. This is what I have so far: Private Sub worksheet_change(ByVal target As Range) If target.Column = 29 Then Thisrow = target.Row If...