Questions tagged as 'excel-vba'

Tagged questions
1
answer

VBA + Excel. Error in code (Incompatible argument type Byref) in Function

The following code: Sub segundograu() Dim a, b, c, delta, raiz1, raiz2 As Double a = Range("B3").Value b = Range("E3").Value c = Range("H3").Value delta = b ^ 2 - 4 * a * c Range("E5").Value = delta If delta >= 0 Then raiz1 = x1(a, b, c)...
asked by 30.09.2017 / 11:56
1
answer

How to change a cell from "General" to "Number" and add comma?

I'm learning VBA and I had a hard time translating a column that has values formatted as "General" for number, moreover, I need those values to be expressed with a comma. Current values (sample): I know there is a simpler way to do t...
asked by 29.09.2017 / 16:10
1
answer

ComboBox does not update and accepts wrong values

Well, I have this code for a combobox, and I have two problems. First: I can not get the combobox to just accept the list values Second: Listing only has value PrivateSubTempCombo_Change()DimvAsVariant,iAsLongWithMe.TempComboIf.Value&...
asked by 13.07.2017 / 18:34
1
answer

Handling internet explorer using VBA

In the footer of this site " link " has an icon that downloads a file .xls. I needed to click on it and save the file, but I do not know how to do it. The code, adapted from another one provided by danieltakeshi, of the two forms I tried to m...
asked by 20.03.2018 / 14:34
1
answer

Class not registered - Imagelist

When customizing my imagelist and listview the following error appears:    Class not registered. Searching Object with CLSID: {7EBDAAE0-8120-11CF-899F-00AA00688B10} I think it's because my Office is 64bit, does anyone with 64bit Office ev...
asked by 03.10.2018 / 16:35
1
answer

VBA - Select a file to attach to email

Good morning, ladies and gentlemen, this is my first question. I never did, because I always find the answer in some forum, but this time, I lost! So let's get my question. I used a code mix on the internet to create this routine that enters...
asked by 08.05.2018 / 17:41
1
answer

Insert comment via function

How to insert a comment with the text of a cell through a function?     
asked by 09.11.2017 / 20:26
0
answers

Interact with Silverlight

Good to all, I'm developing a VBA system that looks for documents (.pdf) on a particular site. But I came across a problem I had never seen, the site opens an IE tab with a Microsoft Silverlight viewer, so I have my problem, I can not interact w...
asked by 03.11.2017 / 17:43
0
answers

How to use the same .xla add-in on two machines on the same worksheet?

I created a file with functions in VBA .xla that can be configured as an excel add-in, but after using the functions in any spreadsheet on my machine and sending the spreadsheet to someone else it can not visualize the function return is that #N...
asked by 08.12.2017 / 13:21
1
answer

Create image in another form

I have the following project: WhenIclickthebuttonitworksperfectly,noproblem,butIwantedtheQRCodetobegeneratedinSheet2forexample.BelowthemacrocodeSubGenQRCode(ByValdataAsString,ByValcolorAsString,ByValbgcolorAsString,ByValsizeAsInteger)OnError...
asked by 01.09.2017 / 13:19