3 in 1 form control function..

**pejoi** · 08-13-2014, 05:54 AM

hi guys,
i had a problem to set a form control with three scrolling sections.example ,i wanna sub-topic A and B scrolling down according to TOPIC section.please help.
formcontrol.xlsx

**samba_ravi** · 08-13-2014, 06:54 AM

{=INDEX(Sheet2!D:D,MATCH(ROW(OFFSET(Sheet2!E6,Sheet2!$F$2,0)),IF(Sheet2!D:D<>"",ROW(Sheet2!D:D))))}
Try this array formula in B6 (Sub-Topic A)

**pejoi** · 08-13-2014, 08:31 PM

thank you very much .It was a really good piece of advice – thanks a million!

3 in 1 form control function..

LinkBack

Thread Tools

Rate This Thread

Display

3 in 1 form control function..

Re: 3 in 1 form control function..

Re: 3 in 1 form control function..

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Use Indirect Function on Form Control DropDown List

How to copy an ActiveX control button to another sheet and keep the name of the button

[SOLVED] VBA Code to have a repeating form control /Active X control (List box) in every row

[SOLVED] Hiding/Showing a Form Control with another Form Control

macro fails to function correctly when called from button form control

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions