Assign Macro Dialogue box not appearing

Every time i drag a new button onto a worksheet and right click i should get a assign macro dialogue box from which i should be able to assign a macro directly. I never get this option whatever i try. Am i doing something stupid? Using 2002. ...

Assign macro to hyperlink

Is there a way to assign a macro to hyperlink. I want to run a SQL when the hyperlink is clicked. ...

Is Excel Custom Toolbar Right for the Job

I decided to use a custom toolbar button for an Excel 2000 spreadsheet instead of a command button on the sheet. When I move the workbook to another directory on a different computer, and click the custom button, it does not work. When I edit the properties and choose assign macro, I see that is is ...

Custom Toolbar with own macros

Have developed a custom tollbar with Excel that runs some macros for me however when I attempt to run the macrios via the buttons I get an error message saying that it is unable to find the relevant macroThis was all working fine until 20 minutes ago Am using XP with Office 2003 - do you know how I ...

Dynamic binding

HiI am reading about virtual functions.I understand virtual functions that:* A member function of a class* Declared with virtual keyword* Usually has a different functionality in the derived class* A function call is resolved at run-time but i don't understand its mechanism.Especially late binding o ...

Activesheet.Unprotect causes runtime 1004 error!?

I recorded several macros in Excel97 to sort a range of cells in various ways. The code didn't look too tricky so I have managed to add some to unprotect the worksheet before sorting and re-protect it afterwards. I created an extra drop-down menu on one of the toolbars and assigned the macros to eac ...

help me please

I recorded several macros in Excel97 to sort a range of cells in various ways. The code didn't look too tricky so I have managed to add some to unprotect the worksheet before sorting and re-protect it afterwards. I created an extra drop-down menu on one of the toolbars and assigned the macros to eac ...

Delphi running an Access macro

I hava a delphi 6 program as a front end to an Access XP database. I am trying to find a command to get delphi to run an Access macro.Can anyone help? ...

Macro to Mimic Double Click Event?

I have been trying to build a macro which will assign a keyboard shortcut to the standard double click event in MS Excel... any light on the matter?Recording the macro in the normal way doesn't help :( any clues dear experts? ...

Excel Search Macro Help

I am a beginner at this so sorry for my ignorance. I'm trying to make a macro that searches an Excel Spread sheet. I plan on using Data validation in cell A1 that the user selects the value they want to see, then I want them to be able to click a button roughly in cell A2 that will initiate the sear ...

Delphi CustomCheckListBox

Hello, i am trying to make a CustomCheckListBox but i cant seem to get it to display my items the box itself creats fine and all the rest seems fine but it wont display my items any help on this matter would be greatly apreciated Thanks.here most of the code im useingunit AlarmCheckListBox;{$R-,T-,H ...

Delphi Onjects

I have a delphi object to store some music information (note, start time, duratrion...) problem is I always get memory addressing error when I run the code,can someone please tell me where I'm going wrong!I declare it in a seperate unit, with all my other declerations as follows:typeSongClass = clas ...

Code conversion from Delphi to C++

Hi, I'd like to know hot to translate this Delphi's intruction to C++ code:Delphi:-------1.- strList :Array of String;2.- SetLength(strList, 45);3.- for i = 0 to Length(strList) ...For those who don't know Delphi, this is what it does:1.- declare a variable, array of strings, no indexes yet.2.- assi ...

Delphi 8 + dll

I need help with using function from dll in Delphi 8.net. Function returns PChar. If I declare function from dll in Delphi8 as it is declare in dll (returning PChar) I can't assign result PChar to String variable (in Delphi 5 it works). If I declare function from dll in Delphi 8 returning String it ...

How to create a VB macro in Excel from Automation...

I'm working on an application which uses Automation for Excel. I have a problem though. My application creates a new toolbar in Excel, but i am unable to figure how to assign some functions to the buttons from the Toolbar. The CommandBarButton has the OnAction property but this runs a Macro in Excel ...

Macro Keyboards for Linux and/or mapping scancodes from 2 keyboards independently?

I'm getting ready to switch (back) to Linux (again). However the one thing that keeps me addicted to my Windows box is my macro keyboard(s). I use them for gaming. I use them for work. I use them all the time. Because of the fact that I actually -use- the numpad and other keys I don't consider the i ...

Entering database password in autoexec macro

I am trying to make my access more secure . i have a login form which caters the need for software security . but even after i created an mde i found out that i can always open a blank access and change table enteries through link table manager , for that i wanted to assign a database password . but ...

How to loop through combo box values and press command button on form with macro

I have form in one of my mdb file which gets opened automatically when I open the mdb file. Now I have two combo boxes on that form first one is Region and second one is country and then I have command button to print.The first combo box gets populated with regions like USA, Asia, Europe etc.. and s ...

F4 to run a macro

Is it possible to press F4 to run a macro?Or How can I assign a code on certain key? ...

checkbox control macro in excel 2007

How do I assign a macro for a selected check box in one worksheet and copy the entire row onto another worksheet? What should I do if I have selected some rows and I want all of those selected in the check box appear on the new worksheet? Anybody out there? ...

calling SQL SP from Excel (macro)

i am new to VB.i am trying to execute SQL Stored procedures from a macro in excel.but i fail to do so. i managed to write a code that imports a table, but not to execute a SP or a function.heres my code:Sub DataExtract()' Create a connection object.Dim cnPubs As ADODB.connectionSet cnPubs = New ADOD ...

global variable in macro

hi, I have create a macro Name mac_Logon_Menu, this macro content 2 screen ie Screen 1 & Screen2. I extract a value from Sceen 1 and assign to a global variable(glo_Test), when i display glo_Test at Screen 2 there value is empty. But when this macro trigger again glo_Test only display out the va ...

A problematic Color problem in Delphi

I am designing a lot of TCheckBox at runtime, and uses mathematical formulas for placing these in columns and rows afterwards on a form.I assign an on click event that is exactly the same on all of them, and everything work,except... Color.My OnClick event is made like this:procedure TForm1.CheckBox ...

Paren-matching macro

I just got done writing a set of Parenthesis-matching macros that map to the navigational keys and behave like (IIRC) emacs does in a console (highlights the matching parenthesis until you move the cursor). Anyways, the macro file (along with instructions is posted at http://www.horningabout.com/jim ...

Invisible bitmap when used in Delphi

I have been developing some ActiveX controls for the past few months and one of users using them has a small problem with some of the controls. When the controls are used in their Delphi environment, the small (16x16) bitmaps are gray instead of full color. Not all of the controls are doing this, ju ...

How to assign a bitmap to a menu item?

I know that I'm supposed to use the SetMenuItemBitmaps() function, however in this specific case this doesn't work.I've created a COM object which adds a new menu item to the Windows popup menu when you right-click on any file. This works well and the menu is added. However, I want the menu item to ...

word mailmerge macro language subst.

I am new to this forum (heck I'm new to almost any forum), and I obviously have a problem...I have a word mailmerge macro and after all is said and done, I have to go thru the resulting merged "catalog" and change some html type codes to Greek letters. I have tried creating a new font obje ...

excel macro question...

I am trying to assign a macro in excel that inserts a row of data into a specified worksheet based on the region column. So basically, I have a report of data from many regions that I would like to filter out into their appropriate worksheets based on the record region. I haven't had much to do with ...

Excel > Macro prompt in VBA Code missing

I was working on my system, doing some VBA code, and when I would build a command button on my Excel spreadsheet, I would get prompted for "which" macro I wanted to assign to the command button. Well, since then my computer took a dive, so I had to rebuild it. Since then, I have gone back ...

how to create a c# macro for excel button using c#

i want to create a macro in c# and assign it to the button in excel. how should i do it.i want even macro defination to be in C#. ...

using a delphi dll

I need to use a dll written in Delphi, this dll includes a port listener so I need to create an instance of the dll assign a port and call some static functions. With static functions I use dll import but I am not sure how to create an instance of the dll, is it possible at all? ...

Ubuntu HOWTO keyboard macros macro in linux

Yup, its indeed possible to have system-wide application independent macros in unix! thanks to xmacros and whoever who wrote a guide somehere i don't remember.Step 1. Install the app aptitude install xmacro Step 2. Record the macro: xmacrorec -d 1400 > ~/quote wait... Step 3. xmacro isn't perfect ...

Controlling Excel 2010 with Delphi 2010 using OfficePartner or COM Automation

I have a project where I need to retrieve data from MS SQL Server and format it into an Excel Spreadsheet. I am using the OfficePartner component to try and make this easier, but I'm having a hard time figuring out how to get the VB help and Excel Object Model and Excel Macro code all to help me to ...

How Do i Assign error div to JQuery Validator Plugin Alpha 2 ?

hey, i got the following code (i fixed the ie6 bugs and stuff)now i need to figure out how can i assign the div the shows errors in eachinput? i saw the demos but the problem is that i want to control on each divposition with my css.. .is that possible ? or anyone can shows me how to doit in diffren ...

jQuery how to assign function to $(this)

HiI have the following snippet to expand/collapse menu items and set thecookie as well.function initMenu() {$('#menu ul').hide();if ($.cookie('the_cookie')=='a'||$.cookie('the_cookie')=='b'||$.cookie('the_cookie')=='c'||$.cookie('the_cookie ...

how to assign alignments in jquery for a table

haii am struggling for thishow to assign alignments for all td's by using "th" alignments intable ...

jQuery Can't assign variable content to some element border color in IE (very weird problem)

there,I'm having this strange problem with IE that I don't know how to fix.Tried countless things, but neither worked and I just can't understandwhy this is happening, it makes no sense to me.First things first... To assign a color to some element border I dothe following which works fin ...

jQuery Trac macro for clueTip?

Since it looks like the jQuery developers use Trac for their projecttracking, I was wondering if anyone had produced a Trac macro forclueTip?I like the look of clueTip tooltips and would love to use them in myown Trac wiki pages. Trac already uses jQuery so hopefully thiswouldn't be too hard. Ha ...

jQuery Need to assign and then track a class after browser refreshes

I like the accordion plug in, but it does not do everything that Ineed. So I rebuilt everything to do what I needed it to... with oneexception.I need to have a "last active state". By that I mean, I need to firstset and then track an active state in my accordion. Using thejquery.cookie.js ...

jquery/livequery assign behaviour to element by class

Currently I am using $(document).ready to bind some behaviours to elements inthe DOM based on a class name (using jquery's .filter) - This works great onthe initial load of the page however these bindings get all screwy when Itry injecting or editing new elements to the DOM dynamically via AJAX. ...

jquery/livequery assign behaviour to element by class

Currently I am using $(document).ready to bind some behaviours to elements inthe DOM based on a class name (using jquery's .filter) - This works great onthe initial load of the page however these bindings get all screwy when Itry injecting or editing new elements to the DOM dynamically via AJAX. ...

jQuery Assign 'active' to nav element

I want my h2 element to be assigned class 'active' when selected, I havetried numerous methods but to no avail, some guidance would be appreciated!function initMenus() {    $('div.menu div.gallery').hide();    $.each($('.menu'), functio ...

jQuery assign function to each matched element

I have a lot of <a> elements on my page, now i want to assign to each of them a function to hide all the elements or in my case, preventDefault();all my a elements look like this:<a href="edit.php?edit=188" class="editB">Edit</a>what i'm trying to get:that the ...

jQuery Assign an css-Property to a div

I want to assign a css-property to all spansThis is the way I do it:$("div#tabhead > span").css({cursor:"pointer"});But I additonally want to hide all spans, but not the span whit the id=0.This is what I want:if ($("div#tabhead > span ...

jQuery assign event handler to multiple events

i can assign a handler to one event type thus:$('.things').focus(function(){$(this).data('foo', true);...});if i want to assign the same handler to several events, say focus, change,and click, what's the tidy way to write it [assuming my handler wants toaccess $(this)]? ...

jQuery ::: Assign a function dynamically?

The function below formats a text field for autocompletion based on the element id. The thing is, that when a user begins typing in the field, another row with the same name will appear beneath it, so that the input fields wind up looking like this:<input id="months" type="text ...

jQuery ::: Assign a function dynamically?

The function below formats a text field for autocompletion based onthe element id. The thing is, that when a user begins typing in thefield, another row with the same name will appear beneath it, so thatthe input fields wind up looking like this:<input id="months" type="text" ...

jQuery get values from a select menu then assign them to an array variable

Hi,I have a menu like this:<select size="8" class="cat2"><option value="com1">vaio</option><option value="com2">thinkpad</option><option value="mob1">nokia</option><option value="mob2">samsung ...

jQuery How to assign on-click events when cloning an element

 Hi everybody,I need the following functionality to be achieved:1) gallery elements include an image and a few clickable icons. One of the icons should clone the element itself2) Each new cloned element should have the same set of clickable icons, i.e. could be cloned as well by clicking its "c ...

assign value to global variable in javascript from jquery ajax function.

 Hello,Hello, I want to assign value to global variable in javascript from jquery ajax function.var trueFalse;$.ajax({            type: "GEt",            url: "url",            data: "text=" + $("#text").v ...