View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J. Hall J. Hall is offline
external usenet poster
 
Posts: 1
Default Get user selected range into RefEdit

I've created a calendar on which a teacher will select a range of
class periods (vertical cells) for which he/she wants to reserve a
laptop computer cart. When they select my custom menu item a form will
pop up with list boxes to indicate the teacher's name, room number,
and building, as well as a refedit control.

I would like to have the RefEdit control field show the range that the
teacher has already selected. (The teacher may then accept the range
that was pre-selected, or may change his/her mind to select another
range.)

The spreadsheet is called "Laptop Schedule.xls". There are 13 sheets
(one for each month and one for lists of teachers' names, room numbers
and building names for the above form.

I know only enough VBA to be quite dangerous, so please go easy!
Thanks...