Use a VBA function to populate list controls with names of months

Populating a combo or list box with the months of the year isn’t difficult. You can type the literal names as the control’s row source or use the MonthName() function in a simple VBA For loop.

When displaying months in a control on a userform (Excel and Word), use the following code to populate a list control named cboMonths with the names of the months:

Private Sub UserForm_Activate()

‘Populate cboMonths with months, by name.

Dim i As Integer

For i = 1 To 12

cboMonths.AddItem MonthName(i)

Next

End Sub

You can use similar code to populate a list control in Access, but use the form’s Load or Open event as follows:

Private Sub Form_Load()

‘Populate cboMonths with months, by name.

Dim i As Integer

For i = 1 To 12

cboMonths.AddItem MonthName(i)

Next

End Sub

Be sure to set the list control’s Row Source Type to Value List (in Access).

Office poll: What is your all-time favorite version of Word?

Note: There is a poll embedded within this post, please visit the site to participate in this post’s poll.

FCC Fridays

Filed under: Features

We here at Engadget Mobile tend to spend a lot of way too much time poring over the latest FCC filings, be it on the net or directly on the ol’ Federal Communications Commission’s site. Since we couldn’t possibly (want to) cover all the stuff that goes down there, we’ve gathered up all the raw info you may want (but probably don’t need). Enjoy!

Phones
Read – Ezze Mobile VI-3
Read – Huawei G5010
Read – Sharp 936SH
Read – Samsung SCH-M710
Read – Samsung SGH-T746
Read – Samsung SPH-M330
Read – Alcatel OT-222A

FCC Fridays originally appeared on Engadget Mobile on Fri, 31 Jul 2009 23:19:00 EST. Please see our terms for use of feeds.

Permalink | Email this | Comments

FCC queries AT&T, Apple on Google Voice iPhone app rejection

Filed under: Handsets, ATT, Apple

Yeah, we’re pretty much all peeved by Apple suddenly ejecting all traces of Google Voice from the app store, but now it looks to have drawn the ire of the Federal Communications Commission, as well. According to a report from The Wall Street Journal, the agency has sent out three letters, one each to Apple, AT&T, and Google. To the latter company, it asked for a description of the Google Voice app and whether previous Google apps have been approved for the store (it has, but that’s another interesting story). To Cupertino, it’s asking the phone manufacturer to explain itself over the sudden exorcism and what involvement, if any, AT&T had in this decision. The report doesn’t make a direct indication of what the letter to the carrier said, but we can imagine it’s similar to what Apple got, plus some doodles at the end of a stick figure letting out an exasperated sigh. In a statement today, FCC Chairman Julius Genachowski said it “has a mission to foster a competitive wireless marketplace, protect and empower consumers, and promote innovation and investment.” Hey Julius, while you’re at it, can you see about Skype and Slingbox for us, too? Thanks.

Update: TechCrunch has published the three letters sent out, all very interesting reads. The FCC asks Apple specifically if any approved VoIP apps are allowed to be used over AT&T’s 3G network, and more generally what are the “standards for considering and approving iPhone applications” and more details into the approval process. It also asks for the contact information of all developers of rejected Google Voice apps, presumably for further investigation. In the Google letter, it seems to be asking if Voice will be able to be utilized in any capacity over the web, without inclusion in the iTunes store. Unsurprisingly, a number of questions to Apple and AT&T concern the carrier’s involvement in which apps or types of apps get rejected. All companies have until August 21st to respond and can request confidentiality on all or portions of their response.

FCC queries AT&T, Apple on Google Voice iPhone app rejection originally appeared on Engadget Mobile on Fri, 31 Jul 2009 19:32:00 EST. Please see our terms for use of feeds.

Read | Permalink | Email this | Comments

LG KG376′s most fascinating feature is its color

Filed under: Handsets, LG, GSM

Style is commonly considered a luxury; form follows function, as they say. The commoditization of phones over the past fifteen years has done weird things to economics, though, which leads directly to phones like LG’s KG376. You won’t find a single item on the flip’s spec sheet that even begins to interest you (unless you’re really, really into 128 x 128 displays), but it seems that LG intends to market the phone directly at women with an eye for style on account of its purple case with pink accents. It’s got an integrated FM radio and an external light (where you’d normally expect a secondary display to be) that’ll go all blinky on you to indicate messages and the like, but don’t get too excited — it seems pricing and availability are still on the downlow.

LG KG376′s most fascinating feature is its color originally appeared on Engadget Mobile on Fri, 31 Jul 2009 16:49:00 EST. Please see our terms for use of feeds.

Read | Permalink | Email this | Comments

Nokia 5800i XpressMusic hits the FCC: it’s like the 5800, only less so

Filed under: Handsets, Nokia

Over the years we’ve found that usually, when a company takes a model number and slaps an extra letter on the end of it, there’s some sort of feature or update they’re highlighting. iPhone 3GS? That one’s easy: “speed.” But if we’re reading this FCC business correctly, Nokia’s new 5800i XpressMusic handset apparently differs little from its older sibling — save for the fact that they’ve removed that pesky WiFi antenna from the thing. Because, really, what would you do with all that connectivity, anyways? Also, while still sporting a 3 megapixel camera, those specs are listed as a 4.6mm on the new handset (the original is 3.7mm). As GSM Arena has pointed out, this could be due to either a narrower field of view or a larger sensor — probably the latter. Not too much more info here, but if you’re morbidly curious, please feel free to check out the gallery below. It’s a blast.

Read – Nokia 5800i XM shows up. Loses Wi-Fi connectivity
Read – FCC teases with Nokia 5800i XM – better camera, but no Wi-Fi?

Nokia 5800i XpressMusic hits the FCC: it’s like the 5800, only less so originally appeared on Engadget Mobile on Fri, 31 Jul 2009 15:43:00 EST. Please see our terms for use of feeds.

Read | Permalink | Email this | Comments

Hitachi’s 720p Mobile Hi-Vision Cam Wooo now shipping in Japan

Filed under: Handsets, Others, KDDI, EV-DO, CDMA

If you’re more concerned about your ability to record stunning high-definition video on the road than you are about your ability to comfortably and conveniently say the name of your phone, look no further than the latest model in Hitachi’s Wooo series over in Japan. Announced earlier in the year, the Mobile Hi-Vision Cam Wooo stands starkly as one of the longest, most unfortunate model names in phone history, but we suspect that the presence of 30fps 720p recording will quickly allay any disappointment you may have with branding. Anyhow, it’s finally available now on KDDI au, the country’s big CDMA provider — so go on, show us what sort of Oscar-caliber stuff you can cook up.

Hitachi’s 720p Mobile Hi-Vision Cam Wooo now shipping in Japan originally appeared on Engadget Mobile on Fri, 31 Jul 2009 14:52:00 EST. Please see our terms for use of feeds.

Read | Permalink | Email this | Comments

iPhone OS 3.0.1 update released, fixes SMS vulnerability

Filed under: Handsets, Apple, iPhone OS

Looks like Apple pulled the trigger on patching that nasty iPhone SMS vulnerability a little earlier than we expected — the iPhone OS 3.0.1 update just hit iTunes. It’s not some lightweight, either: you’re looking at 280MB of love here, so get downloading, friends.

[Thanks to everyone who sent this in]

iPhone OS 3.0.1 update released, fixes SMS vulnerability originally appeared on Engadget Mobile on Fri, 31 Jul 2009 14:13:00 EST. Please see our terms for use of feeds.

Permalink | Email this | Comments

Nokia Surge review

Filed under: Handsets, Reviews, Nokia, ATT, Symbian, GSM, EDGE, HSDPA

Some might say that the phone you’re peering at above is the most un-Nokia-like Nokia device produced in quite some time (if not ever), but remember, this one was custom made for US consumers and AT&T’s audience — something that’s not true for too many Espoo-sourced handsets. Once known as the Mako, Nokia’s Surge (or 6790 in international speak) is certainly unorthodox in design, though the actual specs list is fairly familiar. We get the feeling that Nokia was aiming to hit a very specific niche with this device, somewhere in-between the text-happy handsets adored by tweens and the smartphone desired by Mr. Suit. Care to see if we think Nokia accomplished said goal? Then head on past the break, vaquero.

Continue reading Nokia Surge review

Nokia Surge review originally appeared on Engadget Mobile on Fri, 31 Jul 2009 13:00:00 EST. Please see our terms for use of feeds.

Permalink | Email this | Comments

LG’s BL40 "Chocolate" phone sashays its way through new ad

Filed under: Handsets, LG

We’ve already gotten a pretty good look at LG’s stylish new BL40 phone (also simply known the new “Chocolate”) courtesy of some official shots, but no phone launch would be complete without an over the top ad, and LG’s naturally got that covered as well. As you can see for yourself after the break, the 4-inch, 800 pixel wide display is one of the main selling points here, and if that’s not enough for you, we hear you can even use it to output full HD video to a TV. Unfortunately, there’s still no word as to when it’ll be release ’round these parts, although there’s at least some indication that it could be making its North American debut on Telus.

Continue reading LG’s BL40 “Chocolate” phone sashays its way through new ad

LG’s BL40 “Chocolate” phone sashays its way through new ad originally appeared on Engadget Mobile on Fri, 31 Jul 2009 12:53:00 EST. Please see our terms for use of feeds.

Read | Permalink | Email this | Comments

Next Page »