execute

hi all i have some macros for my Boss, actually i have in each book a button for execute a macro.. but i want add a ribbon and add here my macros.... How to do? thanks

Hi all, In column B I have a conditional format set at "any blank cell in column B shall be filled in RED." I need to make this execute only if the adjacent cell (column A) has an "X" in it. Can anyone help? Thanks in advance! /M

I need to execute 2 commands in N but don't see how I can do that. The value in K is from another program using DDE and is continually changing. When M is >= F I want to Move F to N and move zero to K. I need to zero out K to stop any more processing on this row. N will be zero while this...

Hi, How to execute this command: for %f in (* .txt) do type "%f" >> output.txt In this folder: D:\Desktop\Kami With VBA? Is possible? Thanks in advance!

Hi there I need some help! I need to know how to code if two different ranges contain different values then to execute my code... I have... If Range("A1").Value = "xxx" Then What I need Is the above, but also if A3 does NOT contain a value to execute the code, if A1 contains "XXX" and A3...

Hi, I would like to addin to the ribbon which i failed on my all effort.. can anyone help how to add that on ribbon and execute. Thanks in advance

Hi, I'm trying to check two cell values where both must be within the same range like this... If 1<=Cell a<=6 and 1<=Cell b<=6 then execute This is what I have at the moment... If ws2.Cells(d, "B").Value <= 6 And => 1 And ws2.Cells(d, "C").Value <= 7 And => 1 Then Thanks

If (P10Text.Value = "*" Or P20Text.Value = "*" Or P30Text.Value = "*" Or P31Text.Value = "*" Or PLText.Value = "*") Then Worksheets("PlockSnitt").Activate Could anyone give me a suggestion on how to write this statement in a better way? Does not work that great for me. Basicly I need if...

Hi All, I have an increasingly complex workbook that has numerous subs to carry out specific tasks. One of the subs (lets call it "CellChange") checks to see if any of a range of cells on a worksheet is changed, and if any cells in that range are changed, it will execute 4 other separate subs...

I have recoded a macro to simply delete unwanted cells but I have a button on another tab which I want to control it. I have assigned the macro to the button but how can I get it to execute the function on the other tab in the same worksheet?

Hi, Keep on getting error "you tried to execute a query that does not include the specified expression" My SQL looks as follows: UPDATE TblField LEFT JOIN TblTempStats ON TblField.DomainCatID = TblTempStats.DomainCatID SET TblTempStats.EmptyFields = Sum(IIf([fieldname] Is Null,1,0)); Any...

Hello, I have a couple of ActiveX buttons and if I repeatedly click any of the buttons, I have to click twice in order for it to execute. I can click, go fill out a cell somewhere and come back and I can click once. but If I just try to execute a macro several times I have to click twice. Is...

Hi All, How do you run a timed pop up to pop up on certain opened tabs of your workbook? For example, if I'm running YourSub1 to execute at ie. 12:00pm I want it exclusive for sheet 1 and no other tabs. Thank you all in advance! R/ Pinaceous

Hello, I am wondering if it is possible in VBA to load one Solver model (saved in a range) execute it then load another model (saved in another range) replace the first one and execute and so on. Example: SolverLoad loadArea:=Range("A1:A8") then solve, move on to SolverLoad...

Hello, Excel 2010 First issue: - form still executes even if field is left blank - I don't want the form to execute if certain boxes are blank - I currently have a message box that pops up, but the other fields still execute Private Sub submitbutton_Click() Cells(emptyrow, 1).Value = Now()...

I am trying to create an if statement that will execute code if a particular worksheet tab is any color other than red. I have tried this ... If Worksheets("Master").Tab.color <> vbRed Then but is errs with a "Subscript out of range" error with that line though. The worksheet "Master" exists...

I'm not real polished on error handling, and I'd like someone to sanity check my function. Here's what is intended: run 3 queries (insert, delete, insert) capture rows affected store error numbers and descriptions (if any) provide update status in update log table Public Function myUpdate()...

Hi, I designed a macro where once the user double clicks the file, a userform is displayed. Based on the option selected it will display other forms. When the user opens the form for the first time, it displays the Security Warning and after clicking on "Enable Content" the userform is...

Hello everyone, I have searched a lot in the web for the solution but I cannot find it. The issue is this: I need to open or run a batch or txt file from VB. The code I have is this: Sub Example() Dim RetVal RutaCompleta = Ruta & "\" & "texto.txt" RetVal = Shell("C:\BatchFile.txt") End Sub...

I have opened my recordset rs with adLockOptimistic which set LockType to 3. However after I Set rs = cn.Execute(strSQL) which executes my SQL string, the LockType got reset to 1, which is read-only and I cannot do an rs.AddNew to the recordset. Code: <tbody> Set rs =...