Questions tagged as 'vba'

Tagged questions
1
answer

How to copy the validation rules in vba?

If Range("L9") > (Range("I9") + Range("J9")) Then Range("B8:O8").Interior.Color = RGB(255, 0, 0) Here I want to copy the validation rules if this happens End If     
asked by 04.07.2017 / 15:59
1
answer

VBA - Paste Reports on the determined Sheet

I am assembling a macro that opens a specific report that copies the data, and then pastes it into another worksheet on a particular sheet . But I'm having a hard time sticking to the other spreadsheet. So far we have: Dim as Integer Data=...
asked by 21.06.2017 / 16:54
1
answer

Call the Vba Project password

Hello, I need to run a macro that is Private Sub Workbook_BeforeSave but the worksheet points out that the project is protected and therefore does not run. I wanted to know how I can call the password box, so I can unlock and lock quic...
asked by 14.06.2017 / 14:55
1
answer

DASHBOARD - Can you export to the Browser ?! (Any language for the web) [closed]

How do I import this DASHBOARD made in VBA in EXCEL, to run in browser? In HTML, CSS, JAVAscript, php ... Anyway, I just want it to run in the browser.     
asked by 09.06.2017 / 16:12
1
answer

Auto complete when typing any part of the word

How can I autocomplete text by typing any part of an information within the ListBox using VBA? Example: When you type in "Santos" all options containing this word will be listed / displayed in the listbox.     
asked by 10.05.2017 / 14:55
1
answer

How to concatenate variable with formula in Excel?

Is it correct for me to concatenate a variable to an Excel formula? Excel complains about closing the concatenation: Sheets("FATURA").Select Dim variavel As Double variavel = InputBox("Digite Valor da Tarifa caso nao souber Digite 0,35")...
asked by 13.04.2017 / 21:57
1
answer

Using TransferSpreadSheet via VBA

I'm finalizing my improvement project and have something that intrigues me a lot. I needed to make a report based on the result of an SQL query, which I even asked in Exporting SQL query data to Excel , and now I need to do the opposite and...
asked by 06.04.2017 / 21:55
1
answer

Problems transferring date type from MSProject to Excel

Hello. I'm having trouble transferring some Baseline Start, Baseline Finish, Actual Start, Current Finish dates from MSProject to a worksheet in excel. Here is the snippet of code. Dim xlSheet As Excel.Worksheet Dim wb As Workbook Dim Prog As...
asked by 23.02.2017 / 14:30
1
answer

Filling and importing data with VBA in excel, help in code?

Hello, the situation I am trying to automate in excel, through VBA is as follows: I have two spreadsheets (different excel files), where both have the same heading (with information like ID, Name, Description ... ), but with the columns in differ...
asked by 02.02.2017 / 04:24
1
answer

VBA RowSource with variable

How do I put a variable worksheet in a RowSource? I am trying to concatenate with the last line but it is giving error: Private Sub UserForm_Initialize() Dim plan As Worksheet Dim lin As Range Dim fim As Range Optionapos = True If Optionapos...
asked by 29.01.2017 / 16:42