• Combo box and VBA

    The two possible selections in an Excel combobox: Debt & Common Stock. Let's say that the combobox resides in cell B3. If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use of...

    Nkd5 pointsBadges:
  • microsoft access 2007 & Outlook 2007

    Hello, I am running office package 2007. I was wondering if anyone has found a way that i could set reminders in access 2007 and i would get a reminder email when the time comes closer. I was also wondering if access could auto pull from a date catagory and set it to have outlook send a message...

    Itguy1509220 pointsBadges:
  • VBA Auto Protect

    How can I make the worksheets in Excel automaticaly protected on date

    Georgesal00110 pointsBadges:
  • Excel-Macro Help

    I'm creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I've created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the...

    Forresterdanielle885 pointsBadges:
  • How to search particular data in range of data and everytime save it in a cell

    How to search particular data in range of data and everytime save it in a cell in Excel using VB code

    VBA5 pointsBadges:
  • How to create dsktp shortcut to VB userform created in Word

    I created a userform through VB in Word. I need this form to be accessed via a desktop shortcut icon where only the form is visible when the shortcut is initialized. I created this form in Word. Please help. TY

    Jmitzner5 pointsBadges:
  • Switching custom views in Excel when filtering

    I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and I would like it to...

    Tsbarr15 pointsBadges:
  • Excel RTD and userform

    I need to read data from the spreadsheet into userform anyone can explain it to me? whenever i call the userform the cell stop from being updated/

    JonsIL45 pointsBadges:
  • How supply password in VBA during CompactOnClose for back-end password-protected db?

    Access 2000: Goal: to open and close a password-protected public access db (which compacts on close) and hide the "Password Required" prompt on open and on close. Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link. I have password protected...

    Dlc9ball20 pointsBadges:
  • Range of one cell backcolor in excell 2003

    Dear Sir Madame I am doing a function in Excel 2003 that takes three cells as range data-type. the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as green Can anyone reply to my request? Thanks in advance p.s. I am using the RTD...

    JonsIL45 pointsBadges:
  • commit in vba

    I am new to VBA (within access 2000) and have the following problem I have used a docmd to import a txt file into a table. I then want to use the table data within the same procedure/process using a movefirst command - the problem is that I do not think the data imported has been commited if thats...

    Gordo15 pointsBadges:
  • Visual Basic IF statement…

    I am trying to write an IF statement that will show a message box if the postcode of the customer begins with one of about 20 area codes. I can get it working for one code, but as soon as I add ' Or "HS*" ' (minus the apostrophes) it comes up with Type Mismatch. What am I missing / doing wrong? If...

    Mandi195350 pointsBadges:
  • Automate download from ALV grid to excel using VBA

    I have recently started extracting data into Access using RFC_READ_TABLE. I now need to know how to get results from a standard report via an ALV grid into excel / access. I am using VBA. Thanks

    VB Monkey5 pointsBadges:
  • Header in Word Document using VBA

    How to have different stlye within the same header,i.e. if a header consists of 3 rows the 1st header is bold and the second 2 are not. This way a single page should have a header consisting of 3 lines and each line has different format

    Idks5 pointsBadges:
  • Accountant

    What software proficiency, would enhance my career. There are so many MS Certificates.

    05120 pointsBadges:
  • dynamic visual basic form based on access database table

    I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don't want to have to place 100 picture...

    YitoGraft0 pointsBadges:
  • Visual Studio.Net 2003

    I have a user who when she tries to run a project, recieves the following: "Error while trying to run project:Unable to start debugging. No such interface supported" Similar message appears when selcting Tools, Debug Processes. Software has been reinstalled, as well .Net Framework 1.1. Any advice...

    Ajwhit000 pointsBadges:
  • how to send sms through GSM modem in VB 6?

    hello alll, I am working on a school management s/w. Plz if anybody knows anything about sending sms through GSM modem in vb 6, then reply me. thank you all.

    Poojadoshi0 pointsBadges:
  • Coping and Renaming multiple files using VB6 Code

    Hi Everyone I would like to know how can we copy multiple files from one location to another location, and having the files automatically renamed. I want to copy Images from C:Original to C:Main but i would like VB to automatically rename the files. Naming must start from 000001 to the last image...

    Yugeshang0 pointsBadges:
  • Memory (helpfield) usage in Microsoft Access with VBA

    Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA...

    Gerhemmes0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following