Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel VBA display value of control in a form. (Easy)

Posted on 2014-01-30
5
Medium Priority
?
366 Views
Last Modified: 2014-01-31
I have a spreadsheet with a form frmDemo that has a control called cboPeriod.


1. How do I msgbox a control in this form called cboPeriod??

2. How do I set sheet1 cell A1 is cboPeriod?
0
Comment
Question by:Patrick O'Dea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 49

Accepted Solution

by:
Martin Liss earned 2000 total points
ID: 39822878
1. What do you mean when you say "How do I msgbox a control..."?

2.Worksheets("Sheet1").Cells(1,1).Value = frmDemo.cboPeriod.Text
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 39822881
1. Maybe MasgBox frmDemo.cboPeriod.Text
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39823288
That's it !

Thanks
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 39824030
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2013
0
 

Author Comment

by:Patrick O'Dea
ID: 39824081
Thanks Marty... I will read later.


I read your profile ....
Your years in the business surpasses mine (but not by that much!).
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question