No announcements
Found 2881769 threads
-
0 VotesPass Multidimensional Array From Excel VBA to WebService
My requirement is to call webservice from excelAnswered | 4 Replies | 1889 Views | Created by PB5590 - Wednesday, January 21, 2015 11:59 AM | Last reply by Caillen - Friday, January 23, 2015 9:55 AM
-
0 Votes
Color Words in Text Box
How would I be able to color certain words out of a textBox? Like this: Hello Bob, how are you? Do I need to use a RTF ...Answered | 3 Replies | 3035 Views | Created by pspballer07 - Sunday, April 8, 2007 4:26 AM | Last reply by pspballer07 - Sunday, April 8, 2007 6:04 PM -
0 Votes
Set RGB Array Color From Excel Cells
a different color I wanted to make each label a different color so i did this I put the colors in an excel sheet. column 5 ...Answered | 4 Replies | 1364 Views | Created by Dan_CS - Wednesday, June 1, 2016 1:16 PM | Last reply by Dan_CS - Wednesday, June 1, 2016 6:56 PM -
0 Votes
List words not contained within my array?
I have an array with three 3~letter words : mat, far, let; A second array with a line of text asdmatredtletyxzc I would like ...Answered | 2 Replies | 305 Views | Created by StudiousStudent - Friday, February 14, 2020 11:42 PM | Last reply by WayneAKing - Saturday, February 15, 2020 12:49 AM -
0 Votes
Apply blue background color to Toolstrip control
if you wish to enable the Windows XP Visual styles to your application: Application.EnableVisualStyles();Answered | 2 Replies | 3031 Views | Created by Milzit - Sunday, July 30, 2006 8:27 PM | Last reply by ahmedilyas - Monday, July 31, 2006 1:15 AM -
0 Votes
How to highlight the words with transparent color
> How to make color transparent so that words can be seen after highlighting? I assume you are using Drawing Line object at runtime. You can set theAnswered | 1 Replies | 1299 Views | Created by FireDance - Thursday, November 27, 2014 3:07 AM | Last reply by Herro wong - Friday, November 28, 2014 2:17 AM -
0 Votes
VBA-code length words
Sorry if my English is not that well...I translated my question in another forum where I couldn't be helped. Years ago I got a VBA code to ...Answered | 3 Replies | 369 Views | Created by Hanneke24689 - Saturday, September 23, 2017 5:14 AM | Last reply by Hans Vogelaar MVP - Saturday, September 23, 2017 12:20 PM -
0 Votes
Apply Color to Inbox Messages using VB
Hi Does ne1 knows how to apply color to Outlook Inbox messages using VB? Which is the property/method we can use to do the same?? Manually this can be ...Answered | 2 Replies | 8429 Views | Created by Sabi - Thursday, May 12, 2005 1:41 PM | Last reply by Jean-Nicolas - Monday, October 23, 2006 7:32 PM -
1 Votes
vba Excel 2010, RGB to long color value convertor
Hi all, How do I convert RGB to long color value? For example, RGB(255, 111, 254) is 16674815. Thanks ...Answered | 3 Replies | 32436 Views | Created by ymarkiv - Thursday, February 2, 2012 3:11 PM | Last reply by Siddharth Rout - Thursday, February 2, 2012 3:52 PM -
0 Votes
change color of selected words
Mark as Answered If this answers your question Or UnMark as Answered if it did not. Happy to Help :) My BlogAnswered | 5 Replies | 2898 Views | Created by Mitch_huddo - Thursday, January 13, 2011 5:35 AM | Last reply by Mitch_huddo - Thursday, January 13, 2011 6:29 AM -
2 Votes
Converting Excel vba addin to VSTO - Problem using vba function array
Hi Clyde You need to pass a .NET array that has the data type Object to methods and properties of Office object models that accept an array. ...Answered | 2 Replies | 5004 Views | Created by ClydeDev - Saturday, July 2, 2011 7:05 AM | Last reply by ClydeDev - Thursday, July 7, 2011 9:53 PM -
0 Votes
Populate an array with 'words' for comparison to another word!
delimited by elements of a specified System.String array. A parameter specifies whether to return empty ...Answered | 2 Replies | 3139 Views | Created by Cleg - Monday, March 2, 2009 4:45 AM | Last reply by Cleg - Thursday, March 5, 2009 4:53 PM -
2 Votes
Alternative for array formula (VBA and EXCEL)
1) Split it in two - in code, or in two cells - and then combine the results for your one answer. 2) USe a custom VBA function. Slower, but no limits, and the logic is ...Answered | 3 Replies | 3390 Views | Created by basava1 - Tuesday, February 28, 2012 4:15 PM | Last reply by basava1 - Wednesday, February 29, 2012 1:56 PM -
1 Votes
Apply color to list box item
Could you please help me if I want to distinguish items in the list box by color(preferably, Fore Color not Background color)?Santosh.Answered | 5 Replies | 2009 Views | Created by santoshdarekar - Tuesday, August 2, 2011 8:59 AM | Last reply by Kris444 - Tuesday, August 2, 2011 10:23 AM -
0 Votes
How to reverse an array in Excel VBA
Variant t = Array(1, 2, 3, 4) a = UBound(t) For k = 0 To a t(k) = t(a - k) Next ...Answered | 2 Replies | 3278 Views | Created by Walter David Sanchez - Sunday, May 28, 2017 3:39 AM | Last reply by Walter David Sanchez - Sunday, May 28, 2017 5:04 AM -
0 Votes
How to convert excel cell color to dotnet color
i am reading excel file by EPPlus and many cell has violet color. now how could i detect cell has violet color. so tell me how to convert excel ...Answered | 1 Replies | 401 Views | Created by Sudip_inn - Monday, May 11, 2020 6:47 AM | Last reply by Timon Yang - Monday, May 11, 2020 9:33 AM -
0 Votes
Apply filter to Excel 2013 PowerPivot Report.
Hi, We are devloping sales report in excel 2013 power pivot with datsource from SQL Server 2012 Analysis Services cube, looking for the option to apply ...Answered | 2 Replies | 755 Views | Created by PA Kumar - Friday, April 25, 2014 9:03 AM | Last reply by PA Kumar - Wednesday, May 7, 2014 11:32 AM -
0 Votes
Importing excel data to array
Hi Mark, As to the difference between VBA and VB.Net. I perused this article:Answered | 9 Replies | 10393 Views | Created by A Malhotra - Thursday, December 22, 2011 12:52 PM | Last reply by A Malhotra - Tuesday, January 3, 2012 10:15 AM -
0 Votes
VBA array usage
Look here for the link to the VBA forum. You will probably get faster and more reliable answers there.Answered | 2 Replies | 2724 Views | Created by Traiç - Wednesday, June 10, 2009 1:11 AM | Last reply by Traiç - Wednesday, June 10, 2009 2:05 AM -
1 Votes
Excel to SQL via VBA
Hi FARAZ, Regarding your description, Your requirement is about some programing approach to export excel to SQL Server, which is out ...Answered | 2 Replies | 2132 Views | Created by FARAZ A QURESHI - Monday, March 9, 2015 5:39 PM | Last reply by Eric__Zhang - Tuesday, March 10, 2015 7:55 AM
No announcements
