Questions tagged as 'vba'

Tagged questions
1
answer

Count the number of selected items in a ListBox

I have a ListBox1 list in a userform configured for multiple item selection. Is there a function, statement or way to return the number of selected items?     
asked by 27.04.2017 / 20:21
1
answer

Add photo in excel from local folder

Hello, I followed the steps all the steps here - Add photo in excel worksheet from local folder And everything worked fine. But I wanted to resize the images and align them to the center of the cell - horizontal and vertical. As I did...
asked by 24.11.2016 / 19:24
3
answers

Extracting text with VBA

I need to create a macro in EXCEL that goes to a cell that has a text, and brings me a piece of this text. The problem is that the text has no pattern, just know that somewhere in this text it will be something like NAME: and EMAIL:...
asked by 29.12.2016 / 21:50
1
answer

Identify drive letter or drive letter in autorun

I'm creating an application that should be run by DVD-R, and you also need to run background programs using the process.start("D:\Local do arquivo") command. But there is my doubt: if the client has computer partitions, the disk locati...
asked by 19.01.2015 / 21:04
1
answer

Join duplicate names in a single row

I have this worksheet: IhaveinthespreadsheettheclientELISMARCARLOSRODRIGUESDAMATA,whomade3purchases,twoon10/08/2014andoneon20/08/2014.WhatIneedistoconsolidateallpaymentsonthesamedateonthesameline,ie,looklikethis: The two installments on Au...
asked by 20.11.2014 / 13:12
1
answer

IP Control with Excel + VBA

I'm building some functions for analyzing a table of IPs. I just used VBA for the first time in my life and in my searches I did not find anything that could help me. I need to create a function that searches for the least number that does no...
asked by 08.08.2014 / 01:37
1
answer

Excel button to choose

I want to know if it's possible with buttons or list or with some formula. For example I have a list with names of countries (Portugal, Spain, Brazil) and I want the other list to show me the capitals of these countries. Example: I choose...
asked by 14.07.2014 / 13:53
1
answer

Validate field in VBA

In Mozambique there is a unique tax identification number (nuit), and this number takes 9 digits. How would an application validate nuit under the following conditions? If there are more (+) or less (-) than nine (9) digits, say "nuit inval...
asked by 10.06.2014 / 11:16
1
answer

How to remove brackets from some subfolders I have using an excel macro?

I have a folder called "Franchised" where there are numerous sub-folders with the names of the franchisees. Within the folder of each franchisee there are some subfolders whose names contain brackets. I want to program a macro to remove the b...
asked by 13.11.2018 / 11:34
1
answer

Open Excel worksheet and copy data into VBS

Hello, I have a simple spreadsheet (3 cols and 2 rows) and I'm trying to create a script to open it, copy its data and insert it into another one. Path = "C:\Users\user_name\Documents\excell\planilha1.xlsx" Set objexl = CreateObject("Excel.app...
asked by 29.11.2018 / 18:17