Solved

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

Posted on 2014-01-30
5
326 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
  • 3
  • 2
5 Comments
 
LVL 45

Accepted Solution

by:
Martin Liss earned 500 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 45

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 45

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now