-
Replied To a Post in What movie have you seen lately?
Archer, not a movie but damn funny imo. I'm easy like that! -
Replied To a Post in Excel WinForm combobox not working right
Hmm, that's a stickler of an issue! -
Replied To a Post in Excel WinForm combobox not working right
So are you basically deleting them and then re-adding them according to adjacent cells, which can be dynamic? Is that where Excel is not deleting them properly? If yes, try … -
Replied To a Post in How is the weather today in your country?
That's awesome Reverend Jim! -
Replied To a Post in Excel WinForm combobox not working right
Please keep this thread updated if you don't mind, I'd like to know if it works in a new Excel book on your end too. What version of Excel are … -
Replied To a Post in How is the weather today in your country?
@Reverend Jim, It'd be a short walk today I imagine. -
Began Watching Excel WinForm combobox not working right
Hi, I have a VBA script that places WinForm dropdown boxes (xlDropDown) into an excel workbook dynamically. For some reason, on the 17th box (called "INCL" & i + 1 … -
Replied To a Post in Excel WinForm combobox not working right
Hi jkvt, What is it you are wanting to accmplish after you make these drop downs and buttons? I cannot reproduce your issues so I'm thinking they are coming up … -
Gave Reputation to fourty in Copy Named Range in Excel VBA
Ok, after hours of tearing out myself i realise all i needed to cure my problem was in line 6 of your first reply. Thank you still. Its on my … -
Replied To a Post in Copy Named Range in Excel VBA
You are most welcome and good luck with the rest of your project. If you run into any other issues, don't hesitate to post or even send me a message … -
Began Watching How is the weather today in your country?
How is your weather in your country? I am living in the Philippines and the weather here today is stormy and according to news, we are overloaded of typhoons in … -
Replied To a Post in How is the weather today in your country?
Right now, it is -32 degrees celcius and -41 with the wind-chill. Brrrr. -
Replied To a Post in Copy Named Range in Excel VBA
Hi fourty, did you still need my email or do you have it all figured out? -
Replied To a Post in Copy Named Range in Excel VBA
Hey fourty, I was playing around with row counts and column counts with the named ranges but with no success. Those variables can be disregarded as I meant to remove … -
Began Watching Copy Named Range in Excel VBA
How can i copy data from a named range in a different worksheet and paste it to another worksheet all done without activating both sheet. With all code just behind … -
Replied To a Post in Copy Named Range in Excel VBA
Are there many named ranges in the one sheet that you want the data from? I'm personally not a fan of working with named ranges in code, for these reasons … -
Replied To a Post in What movie have you seen lately?
Watched Captain Phillips last night. Tom Hanks is a really great actor. That was an intense movie imo. -
Began Watching 30 year old newbie
I'm a 30 year old full time worker trying to learn programming late in life. I just wanted to know what programming language is the best to start learning. And … -
Replied To a Post in 30 year old newbie
I started programming at 35, 5 years ago. There will no doubt be many different opinions regarding which language to start with but I'll suggest Java. In saying that, once … -
Replied To a Post in how to create custom popup form when user click on a cell in excel with vb?
Can you post your adaptation of the code? -
Replied To a Post in how to create custom popup form when user click on a cell in excel with vb?
There may be a way to do that but if there is it is beyond what I know how to do. Sorry. Personally though, I would take all that information … -
Replied To a Post in how to create custom popup form when user click on a cell in excel with vb?
Maybe: Dim oComment As Comment Set oComment = ActiveCell.Comment With oComment .Visible = True .Shape.Select True With Selection.Font .Size = 12 End With .Text Text:="Number of Adult: " & noadults.Value … -
Replied To a Post in how to create custom popup form when user click on a cell in excel with vb?
Adapt the following: Dim oComment As Comment Set oComment = ActiveCell.Comment With oComment .Visible = True .Text Text:="Number of Adult: " & noadults.Value & Chr(10) & "Date of Reservation: " … -
Replied To a Post in how to create custom popup form when user click on a cell in excel with vb?
Hmmm, I've never done that but am interested to see if it can be programmed bigger. -
Replied To a Post in how to create custom popup form when user click on a cell in excel with vb?
I'm not sure how to answer that specifically without knowing which you'll be drawing specific information from. However, I have a procedure that creates commments base on the values from … -
Began Watching Javascript for inverting colors of webpage?
Hi, is it possible to invert colors of a webpage using javascript only? If yes, please provide me sample code / tutorial! -
Replied To a Post in Javascript for inverting colors of webpage?
Hi Andy90, I do think this is possible, and probably without too much effort (guessing). However, what would be the event that triggers the invert? And, what exactly is an … -
Replied To a Post in Regular marketing will die in 2014
Think about that AmoI555, there are still many target demographics that have people not up in the digital age and still rely on TV, paper, magazine, flyer, and other forms … -
Replied To a Post in Procceding From Message Box
No problem mavtcr, if your issue has been resolved please don't forget to mark this thread as solved. -
Began Watching Which graphic software
I've just completed my HTML and CSS training and practicing right now. To make all those flashy web graphics on a webpage, the interface desing,little buttons and vector images which … -
Replied To a Post in Which graphic software
Hi Tangerinejoe and sorry you didin't get an immediate response. Sometimes threads get missed and as I look at teh view count, there have only been 6 views so I … -
Began Watching Procceding From Message Box
Hello Dear All, I have a small problem ,though seems very simple,being a newb It is difficult for me. Please Help me I have a message box VbYesNoCancel My code … -
Replied To a Post in Procceding From Message Box
Hi mavtcr, try the following and let us know how it goes: If ACRS.RecordCount > 0 Then If MsgBox("SALARY ALREADY CALCULATED DO YOU WANT TO RECALCULATE ?", vbYesNoCancel, "Pebble") = … -
Began Watching MS Excel and image proportions / aspect ratio / DPI
This may require an expert in MS Excel, I happen to have version 2007. The issue involves how Excel is distorting images when placed in a sheet. Imagine this scenario, … -
Replied To a Post in MS Excel and image proportions / aspect ratio / DPI
While I know this is not ideal and will no doubt require some tinkering but have you tried reducing the scale from 100%? Excel, in my opinion, is absolutely great … -
Replied To a Post in Ruin the above poster's wish.
Granted but then you'll have more to do too! I wish I could sleep more. -
Began Watching Outlook 2013 autofill BCC field in emails
I found a script on ExtendOffice.com that does this perfectly, except the BCC email address isn't displayed in the field. The value is there, but invisible (as it does indeed … -
Replied To a Post in Outlook 2013 autofill BCC field in emails
I see there has been no help so I'm wondering if you've had any success with this on your own? -
Replied To a Post in how to create custom popup form when user click on a cell in excel with vb?
Yeah that looks good! There are so many ways to accomplish the same thing with VBA and that's why I like it. -
Began Watching What movie have you seen lately?
Hi I watch a few movies the past weekend, just to relaxed and not think about work. I saw a few movies. I saw: **The Raid Redemption** - The best … -
Replied To a Post in What movie have you seen lately?
@diafol, I just watched Riddick too and liked it. It was nothing more or less than I thought it would be and would give an 8ish out of 10. A … -
Began Watching Help with a Java code
Hi all I am currently learning Java (and Fortran!) on my own. I have written the following code but for some reason it does not work as it should import … -
Replied To a Post in Help with a Java code
If I remember correctly in Java, the: answer == "yes" will not work because == does not work in that sense with strings like that. I'm kind of surprised it … -
Replied To a Post in how to create custom popup form when user click on a cell in excel with vb?
Sorry, I misread your question. You'll have to define what you mean by appear or activate. What I usually do is disable comboboxes in the userform initialize procedure and then … -
Replied To a Post in how to create custom popup form when user click on a cell in excel with vb?
Sure, wherever you want the new userform to be called you just enter Userform.Show Where Userform is the actual name of the form (like UserForm1) -
Replied To a Post in Bad Grammar
Hah, I missed that but thanks for pointing it out. -
Began Watching Bad Grammar
I can't take it anymore. At first it was only occasionally. Now it seems that every time I turn on the TV someone else is doing it. Doesn't our school … -
Replied To a Post in Bad Grammar
Phor the love ov Bob I really don't believe we need the letter "f-F" anymore. Phrankly speaking, it is a silly letter that always and dephinitely phalls into the category … -
Stopped Watching New Life after Death Theories
Dr. Robert Lanza write a book titled “Biocentrism: How Life and Consciousness Are the Keys to Understanding the Nature of the Universe“ which apparently (I have not read it, and … -
Stopped Watching New Life after Death Theories
Dr. Robert Lanza write a book titled “Biocentrism: How Life and Consciousness Are the Keys to Understanding the Nature of the Universe“ which apparently (I have not read it, and …
The End.